Search results

Hello all, I need to grab a field in a table "tblMain" field named "Interval" and use it to calculate a new date in a different table "tblPass" field name "NextDate" I have what I want working on a form and it works perfectly in the If statement below, ' If Me.Term = "Months" Then '...

Hello all, I posted this on another forum about a week or so ago and still have no answer that works so I thought I'd post it here to see if I get other replies that may solve it for me. I am trying to calculate a "QtyonHand" field from a query and haven't had any luck, I am not sure what I...

Hello all, I am having issues trying to track down the "Unique Key error" that is happening. Can someone please help me understand the code better so I can track down what is happening? I have attached the file and if you open "frmExpandAssembly", then pick the first assembly in the list...

Hello all, This is driving me crazy, and it is beginning to be a very short drive. I am by no means a rocket scientist when it comes to this stuff but I have always gotten by. I am running Windows 10 64 bit on my home laptop and access 2010. I am trying to use a Treeview control however...

Hello, I don't know SQL at all so please bear with me as I learn. I have a query that runs great and gives me expected results in datasheet view. When I try to create the report based on the query, I get the error "multi level group by not allowed in subquery" I copied the SQL statement...

OK I have taken out the redundant fields and created a new table for that data and a link table. I also modified the form (frm22368) to use a subform and the data seems to go into the respective tables correctly. I still cannot figure out how to get a query to work the way I want it. I have...

Hello, I am trying to calculate a date in a table based on another that has been entered already, essentially the expiration date is always 1 day later that it was made. What I want is for the WaterIntExpDate to be calculated as 1 day after the WaterIntLot date after it is entered. I have...

Hello, I am having an issue with what is displayed on a report based on a query. I have attached the file so it makes it easier for everyone to understand my issue, I am by no means fluent in Access but trying to get better and understand what is going on and why, in this case I don't...

Hello, I am an inexperienced user trying to use access to give me a way to ensure data entered into documentation is correct and complete. We have records we are required by reg's to create and maintain which are all filled out by manufacturing folks manually. Quality(me) has to then review...

Hello all, I have started a new database for tracking some info and have run into a snag. I have 2 tables, the first was created with imported from an excel file I was using and the second was created to start to track info on a per machine basis. I need to have the second table...

Hello all, I have a template that seems like it will work well as a starter for inventory control. I need to import my data into the existing tables to start using it, what is the easiest way to accomplish that? I just want to add onto the existing table entries. I plan on using excel to...

Hello, I found a database template that pretty much suits my needs and started to make some changes to make it more closely meet what I needed. In the process I have broke something and cannot for the life of me figure out what I have to do to fix it. Right now the issue is if you open the...

Hello, I am trying to develop a new Inventory Tracking Database and would like input from other who have already done it, maintain one, etc before I get to far. I am not that experienced in database development, a newbie would be the best description. I want to populate the tables in the...

Hello, I want to have 2 field populated when a form loads, the first is a field named NUM_ which I want to have a value of 1 more than the same field in the previous record, then I want another field to use that data in a string to populate a field named Book_Num in that record. I want to have...

Hello all, a newbie here with a simple issue but I can't remember how to do it. I need a sequential number to be generated, which I have done with DMax(), but I also need to now take that number and "pad" it with leading "0's" so I end up with a 4 digit number and save it as a string, example...

Hello all, As if you really needed it, yet another newbie here. I used to program years ago but got out of it. As things changed I am getting back into again, but have lost much of what I new and obviously, programming has also changed. I look forward to your assistance to guide and assist...