Search results for query: *

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

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

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

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

I want a query for the current week but for a particular day of that week. So for instance I want to show all my records for a Monday for the current week. That would be tied to a report to show those records. I would like a query like that for each day of the current week, excluding...

I have 3 cells with text (Text Here) in them (Cell A1, D5 & F8). I want to use a command button to change "Text Here" to the following hyperlink: http://www.johndoe.com, to add that URL for the text in A1, D5 & F8. Can someone please tell me an easy way to do this? Thanks so much in advance!

All, I have a report (rpt_Expenses) with these 2 fields: [date] and [purpose] I want to create a button on a form to bring up the report, but before it opens I want to search for a date range, for the [date] field, and I want to search a value from the [purpose] field. I found code from...

I have a field that has data (fieldOne), but based on my requirements if another has data (fieldTwo), then I want the data in fieldOne to be automatically erased. How would I accomplish this? Thanks for your help in advance

Example below: I have a field on a form called: johnDoe I have another field on that form called: forJohnDoeData I have a combo box with values, which is called "purpose" If I select one of the values, which is: junkMan, from the combo field "purpose" I have information that automatically...

All, I am building a database to help with my Business. I couldn't find any software that would work, based on the requirements I needed, so I decided to build my own in Access. With that being said, here is something I want to do. I have a Query (qry_Expenses) that will be tied to a report...

I have a report and I created a text field on it and all I want to do is when the report is opened, that field will show the previous year. How would I do this? Your help will be greatly appreciated.

I have embed code from Google Drive and it is for a folder. Google drive only gives to views, which are List and Grid. I want to embed the code with the Grid View, but I want the view to be sorted in descending order. Google doesn't have an option to do this, so I am wondering if anyone on...