Search results

So access doesn’t compile the code before it makes the accde file?

I renamed and t did not work, recompiled the code and now it works, maybe it didn't get compiled by access when saved it the first time. Thanks all!

What about the initialization code? Would that be something I wrote into it or is there a setting for that? Thanks

How do I make it a trusted location? When opening the AC de file I get a message that says can’t guarantee the validity of the db or something like that I I click ok and it opens. I should have also stated the the backend is on a server directory.

I got my front end the way I want it and then turned off navigation pane and unchecked full menus in the option under current database, then saved as accde file. Now my switchboard from (a login screen does not respond to the entries in the form and the login button. All works on the accdb file...

Absolutely, I keep forgetting about your blog. Thank You

Main form is filtered to single record. thanks, would it be good practice to run it on current anyway?

I like this idea as well, I wonder which way is more efficient?

The Work Item is not a combo box anyway. It is the name of the field in the qry I am performing the dlookup on.

Thanks all, I've got to learn string concatenation.

Damn Gasman, You got me again! It's the damn contactenation! (but you probably knew that already), I've got to learn how strings are done. Working now. Thanks

=DLookUp("JobName","qryItemListByOrderCurrent","[WOItems]=" & [cboShopItemID]) is written in the unbound txt box, access keeps putting brackets around the control named cboShopItemID (access 2016)

I can't believe I am stuck on this one. I have a form with a simple Dlookup in it to populate an unbound txtBox on a form. Just can't get it to display. See attached for database: 1. User name: orlandoc 2. Password: 3333 Job Name is not populating with the Dlookup. Please help! Thanks

It worked perfectly, I guess I am learning something :p

Thanks, Load event for main form it is.

As soon as the main form loads because it is filtered to one employee and will close once they complete the time entry. MSI that leads me to think in load event for the main form? Thank you

I have a form that that has employee info, on it there is a subform with child fields linked to the main form, what i want is for the subform to go to the last record, there is the possibility that there is not a record for the subform until the first record is added for that employee. I am...

Will do, thank you

Thanks

thank you Is it a setting or is it the way I built the query?