One place you did not check is our database folder. We happen to have a database of runcmds. They might not be the latest, but there is a lot there. Regards, ...
Darrell First, Jet was not happy with my "Not" so the line has to be changed to: AND (((InStr("," & [forms]![Form3]![txtExclude] & ",","," & [OrderID] &...
Hi Istari, It sounds as though you should have two separate messages. One for the case of OverWrite and one for Insert. How does the user know which to choose...
Hello all. I have created a form off of just one Access table. I also have a Pass- Through query that pulls data from a SQL datasource. The record set has 10...
Hi Jeff, Try creating a form using the PassThrough query as the RecordSource and AutoForm: Tabular or Datasheet and let us know what results you get. Regards,...
Thanks, Clive. Will the Autoform have the table as the Recordsource. I'm quite the novice with Access and am having trouble with having multiple datasources on...
Bill, Thanks again for this. I put this code in the afterupdate event of the txtexclude control and it works perfectly!! Doyce ... doesn't ... much ... ...
Can anyone recommend a good book for learning VBscript? I am very familiar with VBA in Excel, though less so in Access, if this will make any difference in the...
Thanks for the response. I do have some questions: -Why do you think I need 2 tables? The rate code will not change, the billing rate will. -Assuming I...
Hi Jan, If your labor codes will never change, then the labor code could be the primary key for the labor code table. If you use a single table to store labor...
Happy Friday pros! I have a form with a text box bound to a hyperlink field. I'm using a "browse" button to use the common dialog to insert the path/filename...
Hi James It really isn't that far Off Topic. In fact, we have a Scripting folder in our Links section. Your Excel VBA will give you a big head start. You...
Query criteria based upon reference to form control (Having comma separated string of multiple values) =================================== Bill, Darrell, ... ...
Ok, so I can't seem to figure out how to store the data that I am pulling from a commbo box! I have a Combo Box (COMBOPART_ID)with row source: SELECT...
The value isn't being saved because the control isn't bound to a field in the recordset. Try the following: Private Sub COMBOPART_ID_AfterUpdate() Me.FORT_COST...
adding on... if it is the 4th column in the SQL statement, you will need to use column(3) since column indexes start at 0 (zero)... also, you will need to...
Hi A.D. Thanks for taking the time to show more ways to accomplish an IN operation. This is a common requirement and deserves attention by us all. Bill From:...
Hi Jeff, You can use the autoform with up to a maximum of 255 fields in the source. Search in Access Help for 'Access Specifications', without the quotes, to...
I have a date field that I'm using to schedule a follow-up date. I need to keep the date within 90 days of the date the form is created. What I want to have...
Yes, i have looked at some of it. Was just looking for a way to use the gift card my son gave me. :-) Thanks again! ... -- Sent from Gmail for mobile |...
LOL Gift cards are good. I guess the best thing is to search the net. Or spend the gift card on a good CD like Bob Dylan's new one of maybe Donavan's new ...
You are most welcome Bill! As rightly stated by you, the topic does come up from time to time, in some form or the other. Best wishes, A.D. Tejpal ... From:...
Hi, Is there any control with a down arrow on which if i click on that it will show the display/content/list, and if I click on the up arrow at the bottom it...
Hey, pros, Does anyone have any recommeded reads (books or 'net sites) for integrating SQL server back ends and Access front ends, especially on the...
Hi, how do you set a "user defined" field in the contacts cards? ... integrating ... differences in ... this time, ... reporting ... db in ... website on the ...