Search results

Number

I think it's stored and displaying correctly. I use the same ID numbers to run reports and that has always worked just fine. Which is what makes me think the 3-digit ones are the wrench in the works, because they're not sequential with the 6-digit ones? Luckily there are only 43 items with...

right now about 700. And there will be more. Lots, lots more.

Row source: SELECT [Inventory].[RecordID], [Inventory].[InventoryID] FROM Inventory; column count: 2 column width: 0";1" bound column: 1 When I set the cbo up with the wizard, I selected to hide the key field [RecordID] so only the numbers associated with [InventoryID] appear in the cbo.

I'm working in an inventory database. I have a form where you can A) enter a new item/record or B) update an existing item/record. I have a combo box that I set up using the wizard to display the selected record on the form by referencing the ItemID number. Some ItemID numbers are 3-digits...

I made an inventory/rental database and I'm now in the process of fully working in it and of course I'm finding bells & whistles I would like to add. It has a search function that works well--user enters in parameters via combo boxes and it returns all inventory items meeting those criteria...

Found what I was doing wrong. I was trying to use Sum where it did not need to be used. What's working for txtExtraWeeksTotal =[txtSubTotal]*0.2*[AdditionalWeeks] I misunderstood what "Sum" actually means in this application....which I'm not surprised at all, I have trouble remembering when...

I'm trying to create several calculated fields (textboxes) in the Report Footer. My report is based on a query. I'm essentially creating an invoice with sums of line items. I'm very new to SQL and all of this, so I think it's something in my syntax, but I can't get some of them to play nice...

Looks like I just needed to close Access. When I re-opened (no processes running after I closed) it saved a back up just fine. Thanks! I was just really scared to close it out, I'm s close to being done with this project I'm terrified of losing it--ha!

I'm trying to save a back-up of my database. Well, it's a copy of one someone here graciously corrected some issues for me that I've been working in all day and adding to. I'm working on a home computer, not connected to any work networks, etc. and it's giving me the error that it is in use by...

Ha! That was what I was secretly afraid of :) I'm going to have some fun formulas, haha! Thanks for your help!

Ah-ha! So I deleted all my text boxes and started adding them back in one by one with the appropriate formula in the control source to see if I could find the culprit. I had some where I was using one calculated value as part of another formula--as soon as I added one of those back in it...

Created a new report with control source of a query. In the report footer, I added an unbound textbox, and set the control source to the calculation e.g. =sum[field1]. Repeated for every calculation, so I've got a total of 6 text boxes, but it is asking for parameters for 4 of them. If I...

I'm working on a report that is based on a query. In the report footer, I've added some text fields with calculated values--basically creating an invoice and totaling specific fields in the report. The calculations are not part of the query. It was working just fine and doing all the...

Success! Thank you! I was missing and/or adding extra parentheses. Weeeee!

I'm working on a report and am creating some calculated text fields. I have a checkbox, and if it is checked, I want it to calculate a value, and if unchecked return 0. Basically I'm trying to get: if checkbox = true, then count[field]*15 if checkbox = false, then 0 I'm very new and am still...

Great! I was planning on splitting it eventually, but wasn't sure if I needed to since it's just me right now. Cheers!

I don't have any real data yet, but would splitting still be a good idea as I'm continuing to work out all these kinks?

@bastanu I just noticed you added an update query. Maybe that's what I'm missing when I tried to update my file. I've rather given up, and saved a copy of your file so I'm working in that now since it well...works, ha! But I'm still curious if that's what I'm missing.

Well, it was working when I quit last night. This morning it's giving me this error. I did have to run a decompile and compress & repair yesterday but maybe there is still something wrong? Or I didn't do that correctly? Starting to feel in over my head here. It happens after I try to add a...