Search results for query: *

We have a situation that started about 2-3 months ago. When we make a query using MS Access, it automatically pulls ALL fields for any and all tables queried. Example: I query for LastName, FirstName; sort by LastName FirstName. No other fields. This is the SQL statement that is generated...

I was required to install a MS Access application that was used in another office. It does exactly what our originally DB did (the one I developed here), but it has more pictures and our boss likes the 'snappy' look. Anyway, the problem is that when one user opens the frontend, no one else is...

Hello All, I am fairly new to this, and am trying to use a module to create an item by joining two fields. It is simple, but I can't seem to figure out how to make it work. We have a field called [lastname] and another called [firstname] - original ain't we? When we run reports, etc, we...

I hope someone out there can help us. The situation is that we have two tables with the fields indicated. Table1: Emply_ID Employee_Name Employee_section Table2: Emply_ID Training_Class Training_Date Comments On form #1, we would like to: ...(1)Select the section that training was...

We have a situation where we have been tasked to input training informaiton about indivdual groups of employees. (Maybe this should be posted to the Access Forms group - if so, let me know) What we would to do is use a single form where the user. (1) selects the group (2) inputs the training...

Is there a way to verify that a user wants to change information? We have a situation where some information is being changed - by mistake - and nobody will admit to doing it, much less admitting to being in the record. (I know - this NEVER happened before!) What I would like to do is make...

We have developed an Access application with a frontend and a backend. The application works great - until we send it to another site for use. Of course, they have to relink the frontend and backend once it is installed - no problem there. However, the new user is not able to input new...

Hello All; We are trying to build a table for tracking times on the Physical Fitness test. Part of the test is the time it takes to swim so many laps or to run a mile distance. Access has time formats where it is HH:MM:SS already defined; however, we only need to keep the MM:SS. Is there a...

We are trying to setup a button that would open a specific application (MSAccess) and a specific file. According to my reference books, this can't be done - but we all know books are not perfect. Our current command line is: Call Shell(stAppName, 1) Where stAppName = "C:\Program...

I have a form with a sub-form that works fine – up to a point. The sub-form is a datasheet listing of cases that are assigned to a specific client. So far so good. The sub-form has a button that will open the specific record(case) if clicked. NOT GOOD. In order to do this, I have to look...

I have a form where labels are highlighted when the field gets focus. The code I have used on this form so far is: Private Sub DENTIST__PHONE_GotFocus() Me!Label19.BackColor = 8454143 End Sub Private Sub DENTIST__PHONE_LostFocus() Me!Label19.BackColor = 12632256 End Sub Now I am...

I have a unique situation here. A customer is assigned a "customer id" (i.e. HELP13579) which stays with this customer until the end of time. When a situation arrises, the customer is assigned an additional letter or number which is the "sequence id" (i.e. W). This...

I am trying to use a drop down menu list for users to select the type of training that they want to review information about. I am using the following code on a button called 'Preview': Private Sub Preview_Click() On Error GoTo Err_Preview_Click Dim stDocName As String Dim...

I am trying to use three option buttons in an option group to allow my users to select which information they want to see. (Eventually, it will be a drill-down type of operation.) Anyway, I have never used the select case function, and am having trouble getting it to work. My current form has...

I am TOTALLY confused! We had a database that had to be restructured due to new management requirements, both in the data stored and the reports requested. I thought I would save some time and work, so... (1) I copied the entire thing to an new area on the network, (2) made the...

I am not sure if this forum is the one I should use, but I will start here anyway. Currently I am trying to automate a routine that requires me to modify a query. I need to change two values in the query to reflect the type of training and another to reflect the FY and Quarter the training was...

I am advancing into another new area for me in the VBA arena. I am trying to pass variables to a report query. I have passed one variable – i.e. year – before, but now I am trying to pass two or three variables. In a query we might see: Class Date Grade =3 =02/10/03 >75 This would be...

How can you - via VBA - add a field to a newly created table? I am attempting to automate a function where the following steps are taken: 1 - create an employee roster (table) using a query 2 - add a field to the table called trained. There are more queries and reports to run after this...

We have a need to insure that individual names are always the same in every table. This is the only way we can isure that reports and searchs find ALL the relevant information needed. What we would like to do is pull the name from table#1 and use it to insert information into table#2. A drop...

I am not sure if this is the right forum, but I will try here first. We have a table that includes the fields: full_name employee_ID start_date end_date What we are tracking - or trying to track - is leave information and how many are on leave for a particular day. We can only...