Search results

So basically, I set up a macro using the now() function on a form. Now I want to write a query that filters those records by date. I can't quite figure it out because the field has both data AND time and when I set the criteria to =date() it gives me no results. Any advice would be appreciated!

Hello, I need some wisdom bestowed upon me. I am trying to set up a relationship between a form and a sub form in way that will let me look up and edit sub form records from the main form. I attached a picture that will hopefully make it clear. I want a user to be able to search for a form...

I am using an excel file to run queries on my database. I originally had it as a linked table, but when you split the database it won't allow people to run queries at the same time because of the excel file. So I am trying to make a macro using the 'ImportExportSpreadsheet' macro and putting...

Not sure if this is the best section to post this in, but I'm hoping someone here can help me out. I have a split database that I have implemented, have about 3-4 people using it. One of the tables in this database is a linked table with excel. The problem I am having is that it only allows...

So I am trying to create a validation rule that only allows the field to start with certain numbers (it is a short text field). For example, the order number can only start with a 5,8, or 9, if it starts with any other number it should be rejected. Any advice? Thanks in advance.

Hello. I have a form I am using for data entry, and it records the date and time every time there is a new entry. However, there are instances where people may have to go back and change information in a record. Whenever this happens, the date/time updates to whatever time the modification was...

My apologies if the title isn't clear, i'm having a hard time articulating what my issue is. Basically, I'm running a query that brings back a list of part numbers and info that corresponds to each part number. The issue is, there is one field, "Special Stock", that is causing duplicate...

Hello, all. I have a problem that's been driving me crazy all week. Hopefully someone can point me in the right direction. So I made a form to enter data into a table. The form only consists of 2 fields. This form is being used by employees using a scanner. What I want to happen is right when...