Search results

Since you're referencing a form within the sql, you need the value typed into the form to become the string value in the sql. Leaving the form reference within the quotes won't do this conversion but the form reference itself is what is passed to the query engine. Therefore you're asking the...

you'll need to create the autonumber field for design table first. Also create a new field in workorders Number(Long) Then create an update query which will copy the autonumber from design into the new field in workorders. you can then delete the old field name in workorders if you wish. If...

Sure that can be done. I'm unclear on your table format though, can you post it? Do you have wk1, wk2, wk3, wk4, wk5 fields which contains the date a person attended? I think you're better off doing this the correct (normalized) way because you'll likely run into other problems later.

have you tried something like WHERE (([XRS-3 repair].[Serial #]) Like "*" & [Forms]![XRS-3 Repair Summary by Serial #]![Serial #] & "*"

don't need to fix something which is working but i thought of a shorter method [hiddenfield].visible=[checkbox] to replace the entire if statement assuming the checkbox only has two states (true/false)

You can certainly do it the way you asked. Did you try it the way I suggested, with a datasheet combining both tables? This will certainly be easier unless it doesn't work for you, for some reason.

Ok, I think I'm understanding better now. With a one to one relationship you just need to include both tables in a query (Record Source) which is behind the form. If the form is in datasheet view, you'll be able to see several people and the fields associated with them (from table B) and the...

You can with VBA, don't know about macro. You'd put the code in the on click event for the checkbox, something like if [checkbox] then [hiddenfield].visible=true else [hiddenfield].visible=false endif or you could gray out the field by using .enabled instead of .visible

So there would be a one to many relationship between table A and B? This sounds like you want Table B to have foreign keys referencing table A. Then you open a form with table A at the top and table B being a subform. Then the foreign keys will automatically be entered in table B. I'm confused...

Yes, tab control would be a good choice. To answer your question, making controls visible will not automatically shift other controls around, they will overlap. You would have to programmatically move fields around.

Define the field in table B using the Lookup Wizard as the Data Type. It will let you select valid data from another table.

If you customize your ribbon, you can find the Switchboard Manager and add it to your ribbon.

I haven't used '.' in dates before, I use '/' so don't know if that could be a problem. You shouldn't need CDate as you should have a string value between the #'s. Have you stopped the code on the Me.subform.Form.FilterOn = True to see what the Me.subform.Form.Filter contains?

do you have your check for all four drop downs only in the fourth drop down in the after update event? Maybe you could show your code pertaining to this question.

Optional allows you to not send that parameter to the function. Thus you can call your function as "Email Me.ProjectID.Column(1), Me.ProjectAddress" since only the first two arguments are required. I think the solution is to convert your NULLs when calling the function such as Email...

Open the table "Switchboard Items" and see if you can tell why it isn't working. The Switchboard Wizard from 2003 builds the Switchboard around that table. So the function/form/report being called from the button will be listed in that table. You can change/fix the switchboard by modifying the...

Is this a one-time import, or something to be done on a regular basis? If doing it repeatedly, and the Excel file keeps the same name, you could link to the Excel table (External Data>Import & Link>Excel). Then write an append query to append the data into your db table. If it's a one-time...

Did the record get added for the parent? Try inputting only the parent data, move to the next record, then move back and enter the child data to see if that works. Open the parent table also and see if/when the parent record is added.

There are other PDF viewers (e.g. Foxit). Maybe try one of them.

You're returning a string value into (I assume) a numeric field. Try NULL instead. FYI: [StartDate]=#4/07/2015# and [FinDate]=#10/07/2015# falls into the true side of your outside if as well as the true side of your second if. Seems like bad logic.