Search:
Type: Posts; User: nO_OnE
Search:
Search took 0.06 seconds.
-
Thanks for the quick response Shaggy!
I was thinking about a few different ways of handling it - like you suggested, writing to a CSV file or something similar, or I could even write data to the...
-
Hello,
Here's my scenario: I have a computer, which is away from the operations desk, that runs some displays (PI ProcessBook displays, OSISoft) which are cast into another expensive corporate...
-
You could try using bookmarks: https://msdn.microsoft.com/en-us/library/office/ff821971.aspx
-
Not entirely sure what you are saying, but if your ID field is auto-incremented, then you can't set it or reuse an ID.
It looks like your delbtn sub is deleting it straight from the database -...
-
There are many, many different ways... It's hard to follow your details, and what exactly you are trying to get.
If you just want the subform to display only a record that matches a selected...
-
There's probably a method of a control you have to set to change the message - I don't mess with powerpoint much, so you'll have to look it up... Perhaps something like:
...
-
That is odd. I don't have Office 2003 anymore, I'm running 2010 and 2013, so I can't exactly compare them.
I would check to see if there are any properties that are preventing it from being...
-
That is not really telling me us much. Without providing us with all the pertinent code, and information, such as what those values are supposed to be vs. what they are, I don't know what to tell...
-
The first question would be: what is 'tmpLeft' set to?
A powerful, and useful tool in vba, is to use the 'Immediate Window' (which you can find under view), and use debug.print to print values of...
-
Ok, Thanks.
I was just curious because I just started getting into Arduinos: http://www.arduino.cc/
-
I'm just curious, but how are you getting the computer to recognize the switch states?
-
You don't have to have the data bound directly to the form as you describe - most of the time with Access I prefer not to.
You can update that specific field, on the databound form directly, and...
-
What issue(s) are you having?
What is in the cells that you are trying to copy - are they formulas?
What do you mean by copy them but not duplicate them?
The one thing I seen off the bat is that...
-
You can do it in the textbox's events (you'll have to do it for both textboxes where you enter "GroupA's number" and "GroupB's number")
Assuming GroupA's txtbox is named textbox1, and GroupB's is...
-
One of the issues in Access with dealing with forms that are directly bound to tables, is that any change you make in any of the fields on your form updates the table, wheither you tell it to save it...
-
You probably don't have the references set to use the Directory functions/methods - I can't remember which reference you need for it, but you can do the same thing with functions/methods within the...
-
I prefer doing it in VBA - you have more control over various things...
Here is a code that queries a "Training Dates" table, and returns records that match "TestDate" with the selection in a...
-
You can try something like this:
Dim wb As New Excel.Workbook
Set wb = Excel.Workbooks.Open(rs1!WorksheetName)
This is assuming that the FIELD 'WorksheetName' contains a valid path...
-
The first thing I would recommend, check your references (everytime I switch Windows versions and Office versions it always gives me issues):
Goto the VBA IDE, click on tools, and reference. You...
-
That's how you learn my friend :)
It looks like 3Com has put a lot of time into this for you...
Most of us on here are here to guide individuals to help them learn, not do it for them, but you...
-
What's with the last couple of statements at the end of your first sub?
Call MySendKeys("{F2}")
Call MySendKeys("~")
DoEvents
'VBA.SendKeys "~"
You are calling a...
-
Another thing I noticed, you don't need to select the cells to write to them, it takes up more time...
Your first sub needs to be re-written:
Sub HandleBlueGreenFormulas(ByVal bcol As...
-
http://stackoverflow.com/questions/12391786/effect-of-screen-updating
-
The application.screenupdating should not have any effect on your code - The only thing it does is saves processor resourses by stopping the Excel Window from constantlly updating while your code is...
-
Good call - This is a very large post, and it's hard to keep up with everything.
dcebb2001,
It would be very beneficial to post ALL of your current code so that we may see if there is anything...
-
No, it does not change anything... All it does is prevent it from graphically updating the Excel Window.
-
No.
You set it to false in the beginning so it stops updating.
Then you run your code.
Then you set it back to true so you can see the changes - It is very important that you return it to...
-
Here is a link to the MSDN site about it:
http://msdn.microsoft.com/en-us/library/office/bb221605(v=office.12).aspx
-
It keeps it from updating the Excel window every time a value changes - it saves your computer from having to process that information every time, thereby speeding up the entire process.
-
Never mind - I should have read the whole problem.
-
It would be faster if you turned off the screen updating - In your code, Excel will process each cell through your loop, and everytime it changes it will process the change, and update it in the...
-
This probably isn't what you want to hear, but since your screen shot shows that you are opening a file in Adobe Reader, you may want to check out Adobe's Developer website:...
-
Lol, glad to be of assistance!
-
The information you provided is not very clear - Don't know really what you are doing.
It would be beneficial for you to clarify exactly what you are trying to do, provide the code that you are...
-
You might want to check out the MSDN How Do I video series. This is the link to the VB videos:
http://msdn.microsoft.com/en-us/vstudio/bb466226.aspx
Scroll down about 3/4 of the way down, and...
-
Hello,
I am looking for an faster method to import excel data into a datatable.
My problem is that we have an old set of spreadsheets that are being used as forms for data entry, and have many...
-
That was simple enough.
Thanks .paul!
-
Hello,
I am working on an aspect of a program to import data from an excel spreadsheet. The primary issue is that the data from the spreadsheet will be coming from different people, and has the...
-
If all of your data follows the same scheme, then yes, it would'nt be too hard.
-
Is the meetingattendees a queried combobox where you joined first/last name (makes it more complicated and will determine how you can solve your issue).
What I would do is add "Guest" to the...
|
Click Here to Expand Forum to Full Width
|