Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. KellyJo

    Parsing for Access standardization

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

    Parsing for Access standardization

    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)...
  3. KellyJo

    Where clauses and aggregate functions.....

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

    Dynamic Crosstab report

    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!
  5. KellyJo

    Dynamic Crosstab report

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

    Dynamic Crosstab report

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

    Dynamic Crosstab report

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

    Dynamic Crosstab report

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

    Dynamic Crosstab report

    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!
  10. KellyJo

    Dynamic Crosstab report

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

    Dynamic Crosstab report

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

    Dynamic Crosstab report

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

    Coding Error

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

    Setting field default value to previous record field value

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

    Setting field default value to previous record field value

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

    Desperate for new record clause

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

    Desperate for new record clause

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

    Desperate for new record clause

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

    DESPERATE for new record clause

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

    Calendar control

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

Part and Inventory Search

Back
Top