Search results

Let's say for example that the primary key of Shares is ShareId then I'd try something like. DELETE * FROM Shares WHERE ShareId IN (SELECT ShareId from Shares Left JOIN ( SELECT Indices.Code FROM Indices UNION SELECT ETFs.Code FROM ETFs UNION SELECT...

I've created and attached a database with two forms, Form1 and Form2 with open and close buttons. All of these work on my system (Access 2013) and should work on yours. Please download this and try it and let us know if it works on your systems.

If the name isn't specified I believe it closes the active form. Your syntax is correct the only reason I can see why that wouldn't work is frmProgressWindow being misspelled or not being open. This thread discusses that but I suggest you read through it to Galaxiom's input on running the...

If you mean by "doesn't work" that the data in the form gets saved anyway then that's because the acSaveNo affects whether or not the form itself is saved, e.g, any change in the size of control if executed when the form is in design view wouldn't be saved.

If [Kit TOTE Number] is a numeric then try rs.FindFirst "[Kit TOTE Number] = " & Nz(Me![totenumber], 0) if it's text the combo box value needs to be in quotes so try rs.FindFirst "[Kit TOTE Number] = '" & Nz(Replace(Me![totenumber],"'","''"), 0) & "'" In either case the Str function...

It might help if you deleted the old file before exporting the new file. The easiest way would probably be with the kill function. I don't remember how this function reacts if the file is open so you will need to look into that.

This page shows the typical way that is set up.

If you scroll down far enough you will find that this says: Why can't you link directly from db3 to db1?

I think you will find that if you just assign the recordset values to the value of the controls (just drop the .Text) you'll get what you want and be able to assign null values. If you actually need to assign them to the the text property then you will have to convert the nulls to empty...

If you just want to view and edit the fields in both tables I suggest making a query for each table with the fields you want, create a continuous form for based on each query, i.e., two continuous forms. Then put these in another form. I call this other form MainForm in the attached database...

I've attached an mdb for Access 2002-2003. If you look in Relationships you will see that FID is the foreign key in table2. table1 is related to table2 in a one to many relationship. I really think you need to tell us what you are trying to accomplish if you want any help that is of any value.

If you mean by same field, same field names, then the query can distinguish the fields by the table name as show in this example query. SELECT Table1.Field1, Table2.Field1 FROM Table1 INNER JOIN Table2 ON Table1.ID = Table2.FID; You will find this query in the attached database and find that...

Suggest using Paul's Debugging SQL in VBA method to find out what is causing it.

Did you see this?

Suggest using a filedialog to do want you want instead of a combobox. I've attached a database that uses one to select an image so that you can see how they work.

How do you consume a MAC address?

Colin's suggestion concatenates the MAX address to the oEmail object; not into the form field. Why and how do you think the sender would see it this way?

I think Colin meant: oEmail.Subject = Nz(Me.txtSubjet.Value, "") & " MAC Address: " & GetMyMACAddresss() OR oEmail.Body = Nz(Me.txtBody.Value, "") & " MAC Address: " & GetMyMACAddresss() if you are using the following function: Function GetMyMACAddress() As String 'Declaring the...

Thanks. That worked on my Window 7 system.

@jdraw Thanks for pointing us to the post. I've haven't been able to get the GetMac function to produce a MAC address on my Windows 7 system but I'm getting info from the CIMV2 class Ok. I don't need that so I just wanted to say that as can be seen here the CIMV2 class could be useful for a...