Search results

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!!

I have constructed an access database which generates a word document, which is a price quotation, including many specs that automatically populate the document from two subforms. This is working great, very quick and it works. I am now struggling to insert a few of the fields into a recorder...

Thanks for the advice; unfortunately I'm using Access 2000. Should have mentioned that. Can't find a similar feature in the view menu.

Due to my totally unstructured method of creating databases, I sometimes find that the databases are containing old tables, queries, etc. that are no longer necessary. However I really can't be sure so I just leave them to take up space. Is there any means within Access to run an audit to see...

I have a table that regularly (several times a week) gets appended with data from an excel spreadsheet from an outside vendor. There are several selections to make, i.e. "import to existing table - import to new table" etc. and I would like to automate this process. Current setup has it...

I have an access 2000 database, which we copied from it's original location to another computer. I now am trying to modify/update the file, and have discovered an unusual problem. The filesize is roughly 75 megs! It is not a huge database, the biggest table has 2200 entries x maybe 8 fields...