Search results

He would only need to add a synthetic key to tblProductSpecs IF there is too be more than one Spec per product. Why did you not consider the possibility that this could be a 1 to 1 relationship?

Yes If you are storing the Date entered in the table you could set the record source of the listbox/combobox to [code] SELECT Table.Value FROM Table ORDER BY Table.DateEntered DESC [code] Now that gets you all of them sorted by their date from most recent on, but not just the last 10 you...

Add a OnClose Event to each form such that Forms[form name of form you want to have focus if this form is closed].SetFocus

As long as you plan on getting the exact same data returned you could put [code] Forms![form1 name]control name.Value OR Forms![form2 name]control name.Value I think.

I believe all you need to do is add code and tell it what to do if the value is false. Because it doesn't know what to do if the value is false (IE get reset), when both are false (after updates) they aren't reset.

Set the column width on your buyer/seller dropboxes to 0"1". Change the latter number till its wide enough to show the whole thing if that's too small. What you're doing is setting the width of each column shown, so you can't show the first column because there is 0 space to show it. This is...

Setting the criteria in the query to Forms![form name]textbox name should do it.

I couldn't make any heads or tails of your form but here's the query I wrote that should get you what you need IF you plan on adding jobs to booking where Booking.BookedOn can be No SELECT Job.Job, Job.JobTitle, Job.StatusID, Job.Profession, Job.JobDescription, Job.AircraftID...

I think what you're looking for is SELECT Job.JobRef, User.UserName FROM Job, User, Assignment WHERE Assignment.JobRef = Job.JobRef AND Assignment.UserID = User.UserID ORDER BY JobRef

I don't know what your table design looks like but, you can run a query to do this. INSERT INTO tblProductSpec (ID) SELECT ID FROM tblProduct

Are we talking fields in a table being updated or fields on a form? If its the former the other guy is correct in that you need an update query. If its the latter you can use the OnClick event of the combobox to trigger an event that runs a query that selects the value you want from tableRef...

If you want to have multiple contacts per project you're going to need a table for that relationship. For example you have something like this I assume: tableContact tableProject ID (primaryKey) ID (primaryKey) <fields> <fields> You need another table which looks like...

To copy from one table to another write a query like this INSERT INTO table I (system_name,port_name,port_direction) SELECT system_name,port_name,port_direction FROM table O WHERE O.primaryKey = selectedItem.primaryKey the last (WHERE) line being pseudo code. Anyway with that particular query...

If odometer_start and length_of_trip are (I'm assuming)textboxes wouldn't they be blank ("") and not null if they are empty? If you step through the code when they are blank what are the values?

The syntax is correct. There are two methods to explicitly refer to a control, yours being the latter. I tried it with yours though and it has the same result. The listbox is null and thus the Control will be set to null as well.

It does need to be multiselect. What I'm not following is, if a control is an object, and the listbox is a control, why can I not declare an object and set it equal to (by reference or value) to a control on the form?

Hi, I have a listbox on my form named participantsListBox I want to do the following dim selectedControl as Control selectedControl = Me.Controls!participantsListBox However I cannot do this because participantsListBox is null. What is the error in my logic / how do I do what I'm aiming for?

I squeezed my field sizes down a bit and figured out I had to keep the page no wider than 6.5 inches in order to keep it from spilling. Struck me as odd as the margins were set for 1 inch and 7.5 is still < 8.5. Oh well. Thanks for your input.

6.75 inches

I have a report that I built that will alternate pages of text with blank pages. I've tried resizing it in case parts were overflowing but that has done nothing, and I don't see properties I might've turned on by accident that would do this. Can any help me fix this?