Search results

Toolbar pain in the...... I made the mistake of removing one of my toolbars in my database. Now I have multiple toolbars opening sometimes, and NO toolbars others....!!!! I have to keep telling Access which toolbars i want to see on reports or forms or whatever. How do I go back to the...

I have 3 different reports that contain information on vacation travelers. One has their personal data (Personal), one has their financial info (Financial), and the last has their travel data (Travel). All three reports have corresponding tables and a common field in each called Record#...

I have a code that activates a search query behind a form. How do I requery the form based on that queries results?

OK, I have 15 different tables and forms in my databse. I would like to build ONE query that will be attached to a button that filters the records according to a status field. This button would run a query that will display all records with an 'X' status. I would like to be able to put...

I have a form that allows a parent to select and login their child. I am tracking the login information in a table called Student_Log_Temp. I need a module that will scan the temp table at login to ensure that the parent hasn't already logged the student in previously. Please help.

I have 15 different tables. All 15 have 2 common fields, (Date, Status). I need to a cummulative count of record status by date. I am trying to either: 1) Append the data from these fields into a new table representing a combination of all 15 tables. -OR- 2) Count each table seperately and...

I am calculating field values in a report. How do I set a field to return a '0' if the value in that field is negative number?

ok...how about this? How would I use DCount to count records meeting a certain criteria in several tables? I need these totals rolled up into a form or unique table? I can do it easily when only one table is involved. The problem I am having is that the data has to come from 15 different...

ok...how about this? How would I use DCount to count records meeting a certain criteria in several tables? I need these totals rolled up into a form or unique table? I can do it easily when only one table is involved. The problem I am having is that the data has to come from 15 different...

OK...here goes nothing... I have 3 tables that contain a field named "Status", (Table_1, Table_2, Table_3). The code in the Status field will be an "A" for new records, "B" for records returned for questions, and "C" for closed records. How do I use DCount to track the combined daily record...

ok...I have 23 tables in this database. Each one has a User_ID field in it. I created another table that contains the various USER ID numbers. I would like a report that lists the IDs in a column and the table in which they appear in a row. I used a query at first and it works but is...

I need to display the combined total record count from 3 seperate tables on a form. Do I use SUM or DCOUNT or what? Thanks in advance!

Hello all! I have an front end password form that I built for a daycare with the help of this forum...thanks to everyone BTW. That piece works perfectly. The parent logs in and the form checks the name and password and then opens a Student Log so that the student can be signed into the...

I have a front end user login. It's linked to a table containing the user ID, password, and actual name. Once the user succesfully enters the ID and password I want a second form to open. that displays the appropriate name for the person logging in. Make sense? Example... James Dunn enters...

I have several databases that I am monitoring. I need to create another database that combines a table (Answers), from each of them quickly. I need a search feature on a form wherein I can type the database name, and have access import the 'Answers' table from that specified mdb. Any suggestions?

I am constructing a program that allows a user to append and review records prior to uploading them to the server. The only problem is that the records come to the user under many different filenames. How do I set up the DatabaseTransfer coding to allow the user to choose the specific file to...

OK...I have a form that carries data entered by the user to the next record. How do I update the form without closing and reopening it?

Please help. I have a table that contains a user ID and question numbers. Each user can have multiple questions assigned to them. This script is supposed to take the user ID and combine all questions on a single line seperated by "|". For instance... User Question A111 A1 A111...

I am trying to capture the elapsed time between two dates that could span many days. I need this time in hours and minutes. Please help. Speak slowly and use small words...I am SOOOO frustrated right now. Thanks!

I am trying to capture the elapsed time between two dates that could span many days. I need this time in hours and minutes. Please help. Speak slowly and use small words...I am SOOOO frustrated right now. Thanks!