Search results

i have 4 drivers out with laptops using an access application but they need to share backend. i have a access database front end and back end what i need to do is have the back end on a server and be able to access it from multiple computers over the internet. dont have a clue how to go about...

hello all and thanks in advance here it what im trying to do i have a client form to input client info i want to take the address field and create a directory on a specified drive when i click a add record button and store that path in the table so i can call up files that will be scanned...

NEED HELP I HAVE A TABLE(GATELOG) WITH GUESTS THA CHECK IN WHICH INCLUDES THE FIELD [PLATE] WHICH IS WHAT I WANT TO SEARCH I ALSO HAVE A TABLE WITH RESIDENT(RESIDENTS) VEHICLES WITH THE SAME [PLATE] FIELD THAT NEEDS TO BE SEARCHED AT THE SAME TIME I HAVE A SEARCH FORM THT A USER PUTS IN THE...

OK NEED HELP HELP, i have 2 tables a table for resident vehicles and one for vehicles logged in at the gate. i have a query for the gate log tha gives me vehicle plate and with another table guest name and location to where they are going. i have another query for resident vehicles that gives...

just checking in to see if anyone could lend a hand

Help Please! Does anyone have any suggestions?

I have a ? for all. i posted a sample database. i seem to have to use alot of forms to accomplish what i wanted. need to find a solution that utilzes the same forms if possible. thanks in advance

the way this is all setup creates a lot of forms. can i use a module or something to do the same thing with the same form.

wayne, this is how it works 1. guest comes to gate gives either resident name or address(lets work on name ) 2. guard clicks button on a form or switchboard to enter a partial last name 3. guard chooses from a list of residents hits enter 4. guest list from that loc# (linked from location...

wayne, i have been working on it but dont think its efficient let me know what u think

ok the flow is as follows frmEnterName then frmGlogLastName then frmGlistSelect when they get to guest list i wanted to select guest if guest expire date is expired then go to a contact resident for which displays resident phone #'s whith a button to open a edit form linked to that guest#...

if anyone could take a look at this thread and look at my sample and give any suggestions it would really be appreciated

wayne, just checking in with ya to see if you looked at the sample i posted

econ, the reason for the keypress event is that it needs to be keyboard driven as much as possible. here is sample. thanks in advance

wayne, it is based on a query but i need to show all the guests so if the guest is on the list but expired and the resident clears them i can just update the guest the guest# of the guest will be passed to the contact resident form which will have a button to another form to update that guests...

ok this is the flow i have a form that user puts in last name that brings up a form with a list box on it with a list of resident names they can choose from they choose a name hit enter key it brings up another form with an unbound list box which lists the guests for that resident this is...

wayne, when i put the code on the afterupdate everytime i move to another record it opens the form i need to be able to move through records choose the correct one hit enter key and have it check to see if the expire date has expired or not then open the the correct form.

here we go. i have a form with a list box that on keyascii return it needs to check the expire date which is a column in the list box and if that date is today or a future date go to another form to enter in the gate log if it is before today go to a contact resident form. i have been trying to...

i figured it out thanks

ok thanks wayne it worked great another ? for the master. the first list box opens i select a resident it opens the other list box but i want the first one to close automatically i tried the after update but it closes if i move to a different record which now makes sense so what event do i use?