Search results

Anybody else have any input? I'm still stuck on this... Thanks!

If I have this for the code: I get this as an error:

I don't know code very well... Do you have a reference site, or maybe just the code I'll need itself? Thank you!!

Nope, no text box. Just the parameter from the query that pops up before the actual form opens, and then the form opens to display the matching records. Then, I'd like to (hypothetically) be able to click on the "New Search" button to look for a different part than the one you initially typed in.

I have a form that I can search for parts in. It's based off of a query that asks you for a part name, then brings up all records with matching part names. I have a button that says "New Search" with a Requery macro behind it. The problem is that when I hit "Cancel" on the button, I get an...

I'm still not sure how you could integrate this into the audit trail for the auditor's name. Sorry, I just got massively busy and I don't have time to dig into it myself. I'm hoping you might have just a quick explanation!! :(

How do you implement this?

Thanks!! I ended up tweaking it a little bit, so now it's >=[Start] And <[End]+1 That gets anything between the starting number and the ending number plus any decimals of it! Thanks guys!

I have a query where I need to pull up a list of numbers between [First] and [Last]. The thing is, sometimes the last number has a decimal, and sometimes it doesn't. If it does, then I need all of the decimals of that number. For example: First = 1 Last = 5 Numbers: 1 2 3 4 5.1 5.2 5.3 So I...

I only had to go 3 columns over before I figured out which column is the problem. I have a column for the location of the product. It is made up of a 3 or 4 number row, a letter, and another number. For example, 2003A1, or 412C3. Not every product actually has a location, so some of these...

1) The oldest dates we have are from 2006. 2) There are two tables I need to filter. The "Product In" table currently has 3,202 records and the "Product Out" table currently has 2,913 records. The total size after I did Compact & Repair (I *think* I did it right) is 37.5 MB. Thanks for...

It's not called [Date], I have a Date In and a Date Out, just to avoid that problem. :D I'll keep dinking with it and post my results.

I don't think you quite understand my question. =P I need to be able to chose the date, so it needs to be a parameter. I have that part correct. What I'm trying to figure out is if anybody knows if there is such thing as too much information for a make-table to hold, since I get this...

I have a table filled with entries of inventory items that I need to filter. I only want to use the entries before and/or on a certain date. I need it filtered to be able to calculate our inventory count as of a particular day, and simply hiding the records after that day won't work: I need...

I'm thinking some help might be a good thing. Most of what I know of access is self-taught, so I'm not familiar with all the terminology and processes. True. Actually, our inventory is in an excel database that is linked into access. One tab for incoming trucks, one for outgoing. Everything...

I'm having issues getting the coding and/or macro right. I've tried both, but I don't really know coding, and I can't seem to get the details right for the condition in a macro... It'd be great if I could get a little help. ^_^ Thanks!

Well, actually, maybe this will span two problems of mine. The subreport is NOT based on the main report. It's an entirely different report dropped into the Report Footer of the main report. The main report is for the trucks in between the two given dates, the 'subreport' is the report for...

Alright, so most of it is pretty self explanatory. I have a report with a nested sub-report (couldn't figure out any other way to get both on the same page). They are both based on parameter queries, and the input is drawn from a form. The user types in two dates, a start date and an end...

I have a whole bunch of reports that have parameter queries to specify data between two dates. The setup is this. I have a forum with two unbound Text Boxes, one for Start Date, one for End Date. Each report is based off of a query, in which I have the date criteria set to pull from my...

This is getting closer to what I need. The problem is that the count in the section footer is counting each line that has that particular truck size, which means it is counting each pallet that had that size truck. I just need it to count that truck number *once*, not once for each pallet on...