Recent content by hmanvel

The criteria is the customer number. Some may have hundreds of records, some two or three. I'm just trying to limit the records to avoid pages of old data. I'm googling how to limit the form to 12 records...

Yes to all of the questions. It is opened by a command button on a customer info form, the code that I posted earlier. Now I am wondering if there is another way to limit records, like in the form instead of in the query. Shouldn't be necessary but I'm willing to do whatever to get this one...

Sorry, you're right I did say report, it's a form but we tend to use it as a report. I actually began this journey designing a new report to do this but it didnt work either so I backed up to this form which is a copy of a known working form, that we can print out. Everything does what it...

I dont think I can send a copy, it's linked to an offsite MYSQL server and all the linkage would be broken etc. It's a sprawling db and we don't even use half of it. Just for clarification; it's a form that I'm trying to fix, not a report. Not sure if that makes a difference or not.

This code opens the form, and there is no code that runs on opening or whatever, no events at all. Private Sub Command76_Click() On Error GoTo Err_Command76_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Water Test 12 Months Form" stLinkCriteria =...

After a few days of tearing my hair out, I'm reaching out for advice. And I'm guessing the solution is simple and stupid, but I just can't seem to make this work. I have a form, that uses a query for it's recordsource. VBA brings up the form, everything is beautiful, works fine. BUT I want...

Just re-read my post, I meant "filter data" not filter date. HM

I have created a form which uses a combobox to filter date "on the fly" i.e. while typing in the combobox the filter is already selecting records. I used code found from a helpful source online, and am just above amateur level. The form works perfectly, however I wanted to do some sorting and...

Thanks folks. That was the problem, file size. It's working now with smaller photos. HM.

I have built a report which uses a table that accesses photos via a text field in a table, which indicates the loction of the .jpg file on my hard drive. Got it working well. There are 10 records per page, I am using it for an inventory identication sticker which includes a small photo of the...

I have designed a report which shows multiple part numbers, part description, and photo, for use with Avery labels (2 x 5 array on letter sized sheet). I struggled with getting the photos to show properly. Got them to work using the "on format" code of: Me![photobox].Picture = Me![Photo]...

I am working on a simple database and form for generating stickers for inventory, each with a little photo of the part with name and part number. Using the method of a text field in the database with the path to each photo on local hard drive. I have a form designed that generates 2 x 5 forms...

Banana - 1) I dont "think" I am using column level security, haven't been able to locate anything within MYSQL (I use Navicat to access database directly when troubleshooting etc.) or within Access. 2)the form recordsource is a select query of a single linked table, however there is no access...

Using Access 2000 as a front end to MySQL database on a web server via ODBC. I stumbled thru the design etc and now have everything working very well such that remote employees can access database without VPN or anything. But I have one big problem and cannot seem to solve it. The main...

tehNellie, Thanks a million. That works!!