Recent content by stell

Perfect! Thank you

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!

Thanks for the response. The shop order number is being inputted via scanner, so I would like to avoid the combo box if possible since it would be a pretty long list and it would take more time. Can you give an example of what that SQL statement might look like if I were to filter the form...

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

Sorry for posting similar, It's kind of an important tool we use at work and I figured this section might have more activity than the excel section (where I haven't had much luck). I did mention this was a split database in the first paragraph. So is the idea to use the matched query to use...

Could you elaborate a little on that? I had the idea to just run the 'ImportExportSpreadsheet' macro and turn it into a local table, but haven't been able to quite get it. Really appreciate the help.

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

I have not. Would that involve VBA? I'm pretty novice in that area. This excel spreadsheet is being constantly updated so I would need the access table to update with it.

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.

Thanks for the response, problem with this method is that the second they create a new record it will record the time/date, even if they don't necessarily enter the data until later.

Thanks for the response, I believe this will solve my problems. I tried changing up my programming but I seemed to have messed something up. Does this pic look right? EDIT: disregard. I figured out I should be using "is null" instead of using the equal sign

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