Search results

Okay I'm extremely stumped now. It works completely fine when I have exactly what I described in the "Detail" part of the report, but not the "Page Footer" part of the report. Any ideas on why this occurs?

There is a datasource called [Amount], all [Amount] fields are filled with currency values, and it is a numeric field yes. It's worth noting I have a text box in the "Detail" part of my report that simply divides the [Amount] and [Ordered] amounts to find the exact cost per item ordered with the...

Hi all! I am using a textbox to try and output the total cost of the items in my report I generate but I simply get the text "#Error" when testing. In the "Control Source" section of my text box ("txt_Tot") I am using to display the total, I have "=Sum([Amount])" but this does not seem to work...

Worked perfectly thanks! Will definitely remember this for future projects, appreciate the help!

Yup I always ensure that the control is unbound for filtering purposes, also I will try this out, thanks!

Hi all! I have a field in a query in which the day, month, year and time of delivery for an item is stored (mm/dd/yyyy format). I know how to limit to the delivery date in mm/dd/yyyy format but is there a way that I could limit it to simply year. I tried just typing "2020" for example, in the...

Oh my gosh I can't believe I forgot about that... Will do, and thanks for the help! Had similar troubles a long time ago, my mistake, sometimes its the simple things I forget to remember.

Hi All! I'm having trouble removing the time on a date/time field in a table. I want to use "mm/dd/yyyy" format but every time I try to make use of the format it adds a time to the field as well. I have tried looking around for solutions (perhaps I'm not looking hard enough) but its getting...

Hi All! I am currently working on a database that houses requisition and inventory data. I want the user to be able to fill in any number of combo boxes with information and click a button to filter to whatever was typed in one or all of the combo boxes. The purpose of this is to be able to...

Literally worked exactly as intended. You're a legend man, thanks!

Hi Everyone! I have tried everything I can find online and I cannot seem to figure out how to hide my previous record button when a user is on the first record. I've tried using the "RecordSet.AbsolutePosition" method but I can't seem to get it to work. Any help would be fantastic! Thanks!

Took your feedback and came up with something like this which seems to work quite well: If Form.NewRecord = True Then Me.btn_GoNext.Visible = False Else Me.btn_GoNext.Visible = True End If In future I am most likely going to create a variable that will track if a...

Hi Everyone! Hope you are all having a nice day! I have been attempting to make it so that the button for "Next Record" that I have on my form is not visible when a user is on a "New Record". How can I go about trying to hide the button and showing it when the user is not on a "New Record"? Here...

Tried changing the "AfterUpdate()" part of the "On Hand" field and it worked. I can't believe I missed such a simple step, you guys made me think though. Effectively I changed it so that when someone changes the data in the "On Hand" field it will change the "Date Updated" field to today's date...

I should have made it more clear but for most items they are updated annually, so the only new data is the updated amount on hand. The default value worked for when I added new items but I need something for when an items on hand amount is being updated. Something like: When "On Hand" changed...

Hi Everyone! I have a query that pulls data from a table and allows the user to edit the amount of inventory on hand. They then have to change the "Date Updated" field to the day they changed the on hand amount. I was wondering, to make it a lot easier (since there are about 133 items and...

Sounds pretty promising. There are going to be plenty of records so the "next record" functions are almost pointless. I also like that this would reduce the amount of work being done in the background. I appreciate the detailed and highly useful advice! I certainly think I'll use "acFormAdd"...

Command worked perfect thanks! Here's what I did to click the button and bring up a new record: DoCmd.GoToRecord , , acNewRec This is in the On Click property

Hi Everyone! Very simple question I'm sure but I can't seem to find a good answer wherever I look. I want to be able to click a button and be brought to an empty new record when it is clicked, I know how to use macros to do it but I would prefer code as I am attaching some other functionality to...

Here is what I did to garner the results I wanted: Count(IIf([Banned?]=0,Null,1))