Search results

RE: Linking Forms Pat, I gave up on the code for this as I was able to accomplish what I needed through a macro. Why the code was not working for me, I still have no idea. The names in the macro are the same as what I was trying in the code... so oh well. At least it is working on...

Tay Tay, That was a real helpful post as well. Thanks for putting in your 2 cents worth. Why would I be grateful for nothing? I stated what my fields and controls names were. I have not changed them from my first post. I also know that you can get an input box to pop-up even when the...

RE: Linking Forms Oh well, screw the code. I still can not get VBA to filter out the records, but I attached a Macro to the button with the same control names and it filters them out perfectly. Pat, I understand that you are a senior member here and know alot about Access programming...

Forms Linking Pat, Concatenating fields was not my preferred method, but I could think of no other way to uniquely identify the records. These records are for laterals on a sewer main. The sewer main is linked to a Project through a file number. The sewer mains can repeat themselves from...

Linking Forms Thanks for the reply Charity, ubt when I tried the changes, it then prompts me with an input message box. I would rather not have to input that long string if I can avoid it.

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...

Updatable PK Pat, I totally agree with you on the updatable Primary field being a bad idea, but in this case it is simply unavoidable. I have the tables' relations set up like that already. I problem was, I did not want to have to type the "fileno" into the 4 seperate fields. I would prefer to...

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...

RE: BLOB Help Anybody? Anybody?

RE: BLOB Help BLOBs are Binary Large Objects. It will store the image in binary form(actual image size) to keep the db size from bloating. So if you store a 50kb jpg, the actual size in the OLE field will be 50kb instead of the embedded size of 400kb or whatever. If you embed the images into...

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...

Query Question Gonna need some more details here... Table 1: What fields do you have here? Table 2: What fields do you have here? Which field is the primary key for each table? Why would you need to take the contents of 2 tables and combine them into 1 table? Typically tables are set up...

RE: Validation code How is it you are wanting to invoke the code? There are several ways you can do it... From the field Lost Focus - In the form design mode, go to the field's properties and click the event tab. You will see the title "On Lost focus". Click the event builder using code...

RE: Query Question Hudson, Good thinking. I have the code tied to a combo box on my form, so checking for zero length was not an issue with me. Glad you added that bit. =) Lamb, Well, one thing is for sure... If I can't answer it, I am definately sure someone here can. These guys...

I used the code in my form to check for null value (Placed in the click function of a button or in form close works well): If IsNull(Me.YourFieldHere) Then MsgBox "Your message here" DoCmd.GotoControl "YourField1 Here" ElseIF IsNull(Me.YourField2Here) Then MsgBox "Your message here"...

Combo Box Code Form 1 = Partsfrm Form 2 = Defectfrm Form 2 combo box name = cmbFrame (cmbFrame was made with the Wizard, pulling from a table with 3 records of 2 fields. 0 - Blank, 1 - Yes, 2 - No. With the results stored in the Table of tblParts.) Form 3 Box to make visible = bxFrame...

RE: Using combobox to set control properties? Fofa, Could you please post an example of the code you would use for your preferred method? I can't seem to get it to read the value of the combobox from form2. I even tried displaying the value into an unbound textbox on form3 which it does do...

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...