Search results for query: *

Hello! I have an Excel file that I need to get into Access. Problem?: I need to "parse" portions of it. What I have is as follows: Roach, Richard 555-55-5555 01-6500-3000 Date In Out In Out Data Data Data Data Data Data Data Data Data Data . . . I need to pull only the Name (Roach, Richard)...

Can anyone tell me how to fix this code so that it works? You can't have an aggregate function in a where clause. s = "SELECT [ID] as PK, ERName AS ERName FROM [Staffing Data] WHERE [ID] = max([ID])" Thanks! KellyJo

Hi! I have a crosstab query that I want to base a report on. The dynamic portion is the "Date Scheduled" field. I need a column for each individual date. Do you know I can code this so that it will work? So vague, I know, but I'm hoping that you know what I mean. I don't want to complicate...

Can anyone tell me what is wrong with this code? When I try to run it, I get an error saying that I tried to assign a null value to a variable that is not a variant data type. Thanks! Private Sub Form_Current() Dim s As String Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset Set...

I have a form that I need to be able to set the default value of "Name" field to the value that is in the "Name" field of the previous record. Example: Name: Adam Bloomfield Date Scheduled: 9/27/04 NEXT RECORD Name: Adam Bloomfield Date Scheduled: 9/28/04 I don't want to enter the...

Hi! I am looking for some code that will help me with a staffing form I am doing. After entering in the name and date scheduled fields, I'd like to be able to go to a new record that will automatically have the name field populated with the same value as the previous record. I am stuck on the...

Hi! I am looking for some code that will help me with a staffing form I am doing. After entering in the name and date scheduled fields, I'd like to be able to go to a new record that will automatically have the name field populated with the same value as the previous record. I am stuck on the...

Man, am I stuck! I have no coding skills and I'm afraid that I won't be able to figure this problem out. I have a form that I want to use to enter employee schedules on biweekly. I select the employee from a combo box and I want to be able to click on multiple dates in the active x calendar...

have a lookup field for my table that pulls its data from Pay period table When I click the drop down in my table, the dates aren't in any order. I think this is because lookup fields are considered text fields. Is there a way to sort my drop down box on the table? KellyJo

I have a form that is based on the following table: Name Period Starting Period Ending Tardies Badge Errors Data is entered into this form every pay period. Is there a way to type the period starting and ending dates into their respective fields, and then have them stay the same through each...