Search results

I wrote some code so the user could push a button and import from excel, the problem is that my unique ID for my data is an autonumber and the data imported is not getting assigned one. How can I fix that? DoCmd.TransferSpreadsheet transfertype:=acImport, TableName:=acTable...

I want to create a button that users can use to import excel data straight into a table. I have all the code for the excel part but I have no idea how to ask the user for the excel file they want to use. Right now I have the filename varible manually set, is there a way that I can bring up the...

Im sure this is a simple syntax mistake on my part but I cannot figure it out, in my code below how would i get the value that is in the string to show up in the message box? Thanks. Dim currentSTRNum As String currentSTRNum = CStr(Forms![STR Log]!txtSTRserialNumber) msgbox ( &...

This is the code i have right now: 'Select the bookmark setup in the template .ActiveDocument.Bookmarks("text2").Select 'Populate the bookmark with this data .Selection.Text = (CStr(Forms!Form1!cmboHullNGSS)) And I have this for about 30 different forms, I have it open a certian document in...

So heres whats happening. I have two tables, both of them have a serial number for a certian part. In one table I have all of the data for that part and in the other table I have the Repair history for that part. Well in getting the parts repaired sometimes they go back into different slots...