Search results for query: *

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

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.

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

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

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!

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

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.

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

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.

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

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

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

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.

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

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!!!:)

...tbl_weeklyMAs.planned_start_date, tbl_weeklyMAs.planned_end_date," 'strSQL = strSQL & "tbl_weeklyMAs.requestor " ' strSQL = "SELECT tbl_weeklyMAs.* " strSQL = strSQL & "FROM tbl_weeklyMAs " strWhere = "WHERE" strOrder = "ORDER BY tbl_weeklyMAs.ma_id;" 'Set the WHERE clause for the QueryDef...

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

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

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

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