Search results

Hi, I'm having issues with a query, it's based on multiple criteria's, a primary ID and a date field. I've narrowed the problem down to the end of the criteria for the ID, it's the & "*" Like [Forms]![SearchBox_CharitiesSalesSummaryReport]![CharityID] & "*" The criteria I use for the date...

Hi, I'm trying to use VBA to update a new column in a table with info I already have in another table. The table I want to update is an inventory details table, it has around 25,000 records. I added a column called "UnitCost", of course the column is empty for all 25,000 records so I would like...

Hi, I've been working the last 10 months on a database and now its time to put it to the ultimate test, real life. I also want to thank those that helped me with some issues along the way! The database is quite large, has about 700 objects and about 35 of those are tables. What I did was split...

Hi, I want to make an IF statement that says the following If Me.OrdersOrdersSubform.Form.RecordSet = more than 1 record Then Do something Else Do something else End IfThanks

Hi, I have a bit of an issue with SQL Update / Insert. I have a form that runs an SQL insert when a field is popluated and it works fine. When this sql insert runs it can add anywhere from 1 new record to 50 new records depending whats on the form. DoCmd.RunSQL "INSERT INTO Inventory...

Hi, I'm trying to get an SQL update to work with 2 criteria's however I can only get one of them working at any given time, any ideas? This code works fine and finds the correct product. DoCmd.RunSQL "UPDATE Inventory SET BarsGiven=" &...

Hi, I've got a bit of an issue with a calculated textbox on a form. Everything is working on the form fine and the calculation does work if a user enters a number in another textbox but what I want to happen is when the form opens the textbox does its calculation based on the values in the other...

I have a form that has 3 subforms, in one subform I have a textbox called "BarsGiven" in another subform I have a textbox "BarsReturned". When you open the form there are 10-20 records that show up and each record has a number in the "BarsGiven" textbox. In the "BarsReturned" textbox it has a 0...

Is this possible? I have a table with product in it and added a yes/no field. On a form I have a combo box that points to that table for all the product. I've made it so when I select an item in the combo box that field will turn to yes and then the next record it won't show up there because...

Hi, I have a form with 3 subforms on it, One subform is for orders, the other 2 subforms show order details. The 2 bottom subforms need to always be on the same record at the same time. If someone selects a record in the outlined subform that record also gets selected in the subform beside it...

I have a form which I need to do a calculation on a field and have it write the answer to the table. I can do it if everything is on the same form or subform using Me.BarsSold = Me.BarsLeft - Me.BarsReturned. But I can't do it when there on different subforms. I took a snapshot of the form and...

Hi, I have a form that has 3 subforms, one subform is linked to the main form and the other 2 subforms are linked to that subform. The 2 subforms that are linked to the same subform and bring up the same data and have the same amount of rows or records, these subforms are set to continious...

I have a query made up that brings up damages, I have 2 tables that cover damages, "Transfers" and "Orders" My query has the data I want except I need to combine 2 date fields. On thing to note is both those tables share a table called "inventory" where all the numbers are actually stored. It...

Hi, I know you shouldn't store calculated values but this is a special case I believe. I'm playing with inventory, we have cases, boxes and pieces. A case could have 4 boxes and each box has 12 pieces. When I transfer inventory I use cases, so if I need to transfer only half a case I go .5...

Hi, I can't seem to find this anywhere, is it possible to set a database to expire in say a couple days or whatever. I'm trying to sell this database I'm making to someone and want to give them a trial version to try before buy. I want to set the database to expire in a couple days, no...

Hi, I've been struggling trying to get a DLookup to work. I have a report that I want to look up some data. I'm trying to make a report that will print an old invoice based on a date and employee and show the correct inventory levels at that time. Right now I have it working so a person can...

I have a bunch of forms created which have an unbound combo box which is used to search the records. On the "record source" for my "employees" form I have a query looking up all the fields in the table and the field "employeeID" with a critera Like [Forms]![Employees].[myselector] &...