Search results for query: *

That's an excellent suggestion. I thought of it also, but decided against it because it would require a ton of manual work on my part. I am looking for a way to automate this process as I will have 850 records every time I run it. How would I write the formula for this? Is just a basic...

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

Also, is there way to tell the report to just put in the day of the month part (15th, 16th, etc.) on the column label? Thanks!

Wow! I got it to work! You are the MAN! Duh, I had my fields named wrong on the frm dates. How should I run my macro to open the frmDates? Should I run it on report open? I think this way, I'll be able to tell it what date to put in right up front. Good idea? KellyJo

I didn't realize I actually had to have a form for Dates!txtEnd. I thought that since it was a parameter in the query, it would automattically calculate. I guess I was wrong. What do I set my control as in the Dates form? Should I have a dates table, too?? Sorry to be so daft, just a little...

I put them in just like you said to: =DateAdd("d",0,Forms!frmDates!txtEnd) etcetera Do you know why this isn't working? The data columns work great, it's just the labels that give me the #NAME error. Could it have anything to do with the fact that only "d" is used as the variable instead of...

AWESOME!! The query works, but now I can't get the column labels to work. The values in the report DO work, but the lables don't. When I'm in Print Preview, after entering in the dtae for txtEnd, the error #Name is in place of where the column lables should be. I'm so close! Can you help...

OHHH!!! There's my daftness coming out again. Yeah, I can assign them. That's not a problem at all. I feel so smart! haha... What do you recommend after I make the 28 columns? Thank you!

This is my coding. The query works GREAT. But, I don't know how to tell my report to do the same thing that this query does for the column headers. Any ideas? Also, I can't restrict my report to just 14 days. Because of the 28 day cycle, the dates are always changing. If we were on a 30 or...

Duane, I looked at your link and it's great. It doesn't quite work for me, though, and that could just be because I'm very novice at coding. It's funny how you get to a point that you HAVE to use it to improve your product... I need something like this, but I need it to automatically add the...

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...

That would be okay, but I'm entering the person in like 15 times in a row, before moving on to the next and my users don't like having to select the name from a list of 875 employees everytime they need to add a new date for a person's schedule. Any other ideas? Thanks for that suggestion...

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...

It's still not working. me!txtName.DefaultValue=me!txtName.Value ' or me!txtName.DefaultValue= chr(34) & me!txtName.Value & chr(34) I changed the field name to ERName (my field), instead of txtName. I didn't change anything else. I'm a bit daft at this, but do you have any suggestions? KellyJo

I tried your code and it doesn't do anything. Can you tell me if I have ti right? Private Sub Date_Scheduled_AfterUpdate() DoCmd.GoToRecord , , acNewRec Me!Name.DefaultValue = Me!Name.Value End Sub I don't know what the Me! part is for. Do I maybe have it wrong? Thank you! KellyJo

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...