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!

  • Congratulations SkipVought 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. caykamanj1966

    Duplicate Records in DataSheet View

    So here are the fields in my database: impacts ma_id maint_category create_date submit_date assignment_group status title planned_start_date planned_end_date requestor I have changed one of the attributes for the "ma_id" field for indexed to have yes (no duplicates). The ma_id field has...
  2. caykamanj1966

    Duplicate Records in DataSheet View

    No they don't. It is exported into an excel format and then I copy those records into my Access Database and the fields match what I have in my Access Database.
  3. caykamanj1966

    Duplicate Records in DataSheet View

    I hope someone can help me with this. I have embedded datasheet on a Form. I have to access an external database everyday to export the records as an excel file and paste them into my datasheet. These 2 databases can't talk to each other, because that has not been approved and probably never...
  4. caykamanj1966

    Continuous Form Updating

    I have a continuous form that displays records from a query. I have a checkbox that is set to "True" when new records are added. Based on that, when that checkbox is True, for the records that are shown, I want to copy values from one field to the other. I want to do this when the form is...
  5. caykamanj1966

    Help With Search Form Results

    I figured out the issue. I did a SQL View and noticed I had a field that was "Ordered By" that was giving me the issue. I put that in for the something else and neglected to take it out. Once I took that out, it worked perfectly! Thanks for hanging in there with me!
  6. caykamanj1966

    Help With Search Form Results

    I just figured out there is something going on with the data in this table. I put [Start Date] [End Date] directly in the "Criteria" of this database and another and my other database gives the correct results, but this database does not. If I put in a search range of like, 1/1/2001 and...
  7. caykamanj1966

    Help With Search Form Results

    dhookom, I have that piece of code after the "End If" and went to the form and did a search, but nothing appears in the "Immediate" window.
  8. caykamanj1966

    Help With Search Form Results

    Sorry dhookom, I can't figure how to run this code. This beginning to be nerve racking.
  9. caykamanj1966

    Help With Search Form Results

    dhookom, I'm sorry, I am not familiar with doing this. I put "Debug.Print strWhere" at the end of my code. I did bring up the "Immediate" window, but I do not know how to run the code to see what it is doing.
  10. caykamanj1966

    Help With Search Form Results

    All, I have another issue with this code. I hope someone can help me figure this one out. When I try to do a search date range for the below, it is not giving me the correct dates. Say for instance if I put in a range of "5/1/2023" for "txtFilterPlannedStartDate and "5/23/2023" for...
  11. caykamanj1966

    Visibile Property

    Thanks for that suggestion. I will do that. Do you have any idea how I would accomplish my question?
  12. caykamanj1966

    Visibile Property

    I have a continuous form. When that form is opened, I have the following code on the "OnLoad" event: Me.paste_hyperlinkNow.Visible = False Me.Command88.Visible = False I don't want those objects to show when the form is opened and yes I know I have to rename the command button:) Then on...
  13. caykamanj1966

    Hyperlink Text of a field

    I found a solution. I will just create a field to take the link and command button with this code FollowHyperlink txtField1 I paste the link in the field for the link and click the button, then it opens the file for that link. Problem solved.
  14. caykamanj1966

    Hyperlink Text of a field

    I have a question about hyperlinks on a continuous form. Say for instance if I have a continuous form that is showing results for 5 records. Those below is just examples: The fields for those records are as follows: txtFirstField, txtSecondField, txtThirdField, & txtFourthField My...
  15. caykamanj1966

    Help With Search Form Results

    dhookum thanks again my friend! As usual, you are tha' BOMB, meaning good:) That worked! Andrzejek, thank you for pointing out my naming convention for combo boxes and I have fixed that. I really appreciate everyone's help with this and I hope you guys have an awesome day. Go Nuggets!!!:)
  16. caykamanj1966

    Help With Search Form Results

    All, I have the below code for a search form. It works perfectly, but I have a unbound field (combo box) called: txtFilterStatus and the field in the table is called: status. That combox has several values and 2 of those values are: Activated and Deactivated. If I search for...
  17. caykamanj1966

    Available Numbers

    All, I have a field called: available_numbers. I would have a block of numbers from: 1001 thru 1010. I want to be able to have a those blocks of numbers entered somewhere (i guess another table), not sure where they should be stored. So if number 1002 is already taken and someone tries to...
  18. caykamanj1966

    Get Yesterday's Date

    I found what I needed, which is this: Date()-1 Thank you all for all of your help, all the time!!!
  19. caykamanj1966

    Get Yesterday's Date

    In the criteria field of my query, I am trying to pull all records that are from yesterday. This is what I have but it is also getting, the previous years record, but the current day and month, with previous year. So for instance it is getting all records from yesterday (i.e 4/18/2023), but...
  20. caykamanj1966

    currentWeek excluding weekends

    All, I don't want the user to select a date. So this is a weekly report that we review activities for the week. So this is what I really want. For instance, if all records have been entered for a Monday of the current week. When the user opens the report, he will see all...

Part and Inventory Search

Back
Top