Search results

there is a way to use code to extract the file name, but i can't remember what it is off the top of my head....the other way, as you asked, is to change the properties of the database to say whatever you want...click on Tools>Startup and you can change the name, which form to open, icons, etc...

when replying to this message, pay attention to this post as well...he posted the same question twice, worded slightly different.... http://www.access-programmers.co.uk/forums/showthread.php?t=93022

here's what i've done (assuming you're comfortable with VBA): unbound combobox on main form....the source is a query and the proper "bound field" - bound field being the link between the main form's table and the subform's table (table1.id and table2.id, for example). then, in the afterupdate...

exactly and it shouldn't have any...it's all accomplished from the combobox... and it shouldn't....the form that opened it remains open...this is one of the reasons i'm baffled....no code, yet there is a problem... not exactly....the form is maximized when loaded...if the user changes this...

i was hoping that by looking at the code that goes along with the forms would help....i doubt it has anything to do with the data in the tables...i tried importing the tables but problems arise because i'm using functions that are available via MSSQL and not Access (remember, i'm using Access as...

here are the forms in question (without tables)...maybe from the forms you can determine what is going on....can't post the tables, sorry...

i can try...the tables are in mssql and i use access as the frontend....when you export the tables from mssql to access it changes the table names...i'll see if i can export them and post it here...most likely tomorrow...

there is code in the Form_Load() and Form_Resize() - both of which are on the main form and not the subform. the Form_Load() sets the recordsource for the subform. the Form_Resize() sets the size of the subform and positions the combo box based on the users screen size. the only other code is...

on the main form in question, i have vba code in the "Form_resize()" which lines up the combo box and the subform and corresponding labels....it appears as though it first is trying to resize the forms...could this be what is causing the error? would closing Access cause the form to call up the...

yes, it is still open...if the form is closed everything works fine...if, however, the user tries to close Access all together, that's when the run-time error occurs. like i said, with the other forms on the switchboard the user can close Access with no problems.....only this one....that's why...

no....one reason is because i don't know if it is in the way i designed the forms...if it is, then rebuilding would have the same result...

I have a Switchboard form that gives the visitor several options from which to choose. All work fine except one. The one in question loads just fine. This form has an unbound combo box used to search the database. When the user selects an option from the combo box the subform is then populated...

ok, i see what you're saying...this page here has a downloadable example of using a triple state checkbox. it's not a wildcard, it uses a Case statement, but to me seems the most logical since there are only three options for it. http://www.microsoft-accesssolutions.co.uk/triplestate_checkbox.htm

in the table design look at the checkbox field. under format at the bottom it will say Yes/No or True/False or On/Off. if it is setup as Yes/No then in your query do something like this: SELECT Table1.checkbox FROM Table1 WHERE (((Table1.checkbox)=No)); or SELECT Table1.checkbox FROM Table1...

how do you have your checkboxes setup? checkboxes are usually Y/N, T/F, On/Off. if you have this then why not use and If/Else. it would be only one or the other, no range of options.

thank you so much...i knew there was an easier way (actually a correct way) but i sorta had tunnel vision...i couldn't see anything but my incorrect solution.

i figured i was going at this the wrong way...you're correct when you say i have one table with several 1-to-many relationships. the main table is the ehs_labs with 1-to-many relationships to my vio_*_mid tables. let's see if i understand you correctly and start down the right path (finally)...

sorry....i read your question too quickly...you're right, it talks about LIKE but not between....my bad :o

i have not tried this myself, but here's what MS has to say about date wildcards. http://office.microsoft.com/en-us/assistance/HP051881851033.aspx

ok...so i've taken a closer look at what i have and what i should be getting....i was a little off yesterday because of an oversight on my part. here's what i have: vio_chemical_mid ---------------- lab_id safety_survey_date violation_id violation comments d15cc 6/1/2005...