Search results

I get an error that says: "Syntax error(missing operator) in query expression '[txtLineID] = 3PW4000ExMH0+00A-13+00' ". What does this error mean? (That long string is a concatenated field I am using as my PK) Any help would be appreciated. The code I put in is as follows: Private Sub...

RE:Linking Forms Hayley, I have tried using your code on my form, but I get an error that says: "Syntax error(missing operator) in query expression '[txtLineID] = 3PW4000ExMH0+00A-13+00' ". What does this error mean? (That long string is a concatenated field I am using as my PK) Any help...

I have 4 tables created. In the main table, the PK is named Fileno. This is an text field with a length of 10. This same field is also the foreign key in my other 3 tables. I have all the information brought together in a query and have a form created based on the query. Now what I want to...

I am working with BLOBs in an OLE field. I have it write the binary file to a temp file like this: c:\temp\tmpfile.jpg, but when I open the form up, it says it can not locate the file(because it has not been made yet). Anybody know how I can get the code to see if the temp file exist and if...

I am trying to make a photo album database. I have done alot of research on the different methods of obtaining this. I don't really like the storing of the paths as I can not really secure the photos. I also do not want the database bloating associated with embedding the files in the OLE...

I am creating a database to safety inspections. I start the inspection on form one. Then when i go to the 2nd form, there are a series of comboboxes with yes/no answers. What I am trying to accomplish is if I answer "no" to any of these comboboxes and click the button at the bottom of the...