Search results

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

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

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

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

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

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