Search results for query: *

I am trying to recreate the wheel , as the saying goes. I have access to a form that has an unbound combo box where a code is entered and the resultant search gives you the rest of the info. We are trying to do the same thing for our applicaion, however, we enter an airline code instead...

I have a form with about 5 sub-forms which are accessed via tab control. Once I reach the last field of a sub-form how can I (1)continue to the next sub-form/tab. OR (2)if I am on the last field of the last sub-form how do I either stop going anywhere, or go the the next record on the main...

Could you PLEASE take 5 minutes to look at this code? I can not get the IF statements to execute. If "[Data-Basic.SSN]" Then stLinkCriteria = "E_Month ='" & Me![Month] & "' and " & "[E_Year] = '2003'" Else: If...

FIRST A THANK YOU TO EVERYONE WHO HAS HELPED ME IN THIS NEW ENDEAVOR OF MINE! WITHOUT YOUR HELP, I WOULD STILL BE ON PAGE ONE! Now to my current problem: I have a report with a Sub-Reports inside of it. The query for the main part of the report is a link between table_1 and Table_2 as...

I hope this is the place for this question. We have a report that is supposed to print out individuals who have birthdays for the month selected in a form. When I run the request - it works. When others run the request - they get 'data type mismatch'. Here is the basic info: TABLE-1...

Is it possible to increase the number of switchboard options from the default 8? I tried to change the properities, but when I went to the switchboard manager it still limited me to eight entries. I need at least 4 more for a total of 12. THANKS. H. Jessen "Now I know more, and I feel...

Can anyone recommend an online course, or book learning course, for VBA? I am having to use it more and more, and would like to become educated in the right way rather than in the 'fire fighting' mode. THANK YOU. H. Jessen "Now I know more, and I feel dummer"

I can't figure out the logic needed for this query and I am sure once I see it, I will feel really dumb! I have a table that has the following fields: Name ID Topic Date Score FY/Qtr The problem is, I need to see who missed specific training for a particular quarter of a fical...

I have a form that produces a datasheet output and covers different types of training that each employee has taken. Each of the training topics has a different grade spread. i.e.; Topic Grade Range Shop Safety 50-41 (Exceptional) 40-31...

We have a DB where we track both the local residence and the legal residence of individuals working in our office. What I am trying to do is setup a form so that when it appears: - If the Legal Residence is blank then produce a msg box that asks if the local and legal residence are the same...

I have JUST distributed a front-end DB to a number of users here, and have come across a problem that makes the overall DB useless in their eyes. I have TWO front-ends - one for individuals who can make changes to the information in the back-end DB, and another for those with read-only access...

When I open my db frontend, I have a startup screen, and then a switchboard where the users can select whcih forms or reports they want/need. Even thought I have made a menu bar that is blank, and removed all other menu bars from the application, the "minimize", "restore&quot...

This may seem like a very basic question, but I am having trouble figuring out the SAFE and CORRECT way to do this. I have over 500 records already in my database, and need to import information to fill specific fields associated to each records. The information currently is in MS Excel. Can...

I have a large databse (MS Access 2000) that has about 10 active tables. The common thread in each table is the emply_ID. The users can look at the data in the tables via a form with 9 sub-forms accrssed via tabs. My problem is that when we try to add a new employee data, MS Access will...

I have a report that produces a datasheet output and covers different types of training that each employee has taken. Each of the training topics has a different grade spread. i.e.; Topic Grade Range Shop Safety 50-41 (Exceptional) 40-31...

Okay, here goes. I am fairly new to Access, but have been told that I am the most qualified where I work. I am trying to do many things, but the ones I am having the most trouble with are: (1) Printing a report (call it employee_report) based on the current record I have displayed on a form...