Search results

Hello, we just upgraded to Access 2010 from Access 2000. Most of my users are volunteers who know nothing about Access or databases and so I like to restrict them to as few options as I can - including MenuBars and ToolBars. In Access 2000 I coded the following to hide (and show) MenuBars...

Hello, we recently upgraded Access from Access 2000 to Access 2010 (please forgive us for not upgrading intermediate versions of Access but we are a non-profit organization with limited funds) and I am encountering some problems which I am hoping you can help me with. I was getting a ‘missing...

Hello, I’m not sure if this is an appropriate question for this forum but I downloaded the ‘Access 2007 Runtime’ program from Microsoft’s Download Center onto a PC which does not have Access. I then installed one of my Access applications but when I try to run this application I get the...

Hello, I have a Form with the following four fields - JPGA, JPGB, JPGC and JPGD. The tab sequence for these four fields is 1, 2, 3 and 4 respectively. I use the ‘AfterUpdate’ event procedure to do some data validation and when I find an error I want to be able to focus the cursor back to the...

I have another embarrassingly simple question - how do I read a Table using the Primary Key? I have a Table (called ‘Sciflat’) which has a two-field Primary Key (‘Genus’ and ‘Species’). I want to retrieve the ‘Family’ of a specific genus and species. I thought the SELECT statement would do the...

There has got to be a simple solution to this problem but I can’t seem to be able to find it… I created a Form to add records to a Table. There are Command Buttons to Save the record and Close the Form. I also load half a dozen fields with default values using the OnCurrent Event Procedure...

Hello, I created a Form to add records to a database and one of my users accidentally scrolled the Mouse wheel while on the Form. This action added several blank records to the table. Is there a command I can use to temporarily disable the user's Mouse wheel? Just curious. Thank you.

Hello, I created a Form where I display a JPG image using the following code: Me![DRImageFrame].Picture = Me.[DRIP] This works great. If I view the same JPG using "Windows Picture and Fax Viewer” I am able to zoom in on the image. And so my question is, is there a way I can zoom in on...

Hello, I created a Tabular Form where each row has a check-box which the user can check if he wants to view the record in detail. I also have two Command Buttons which run Update Queries. One query checks all of the boxes and the other query clears all of the boxes. I also turned off the...

Hello, I would like to check if a file exists before I process it. Is there a command or routine I could run which would determine the existence of a file if I provide it with a path\filename, e.g. "C:\Photos\01234.jpg"? Thank you.

Hello, I’m sure this must be a common problem but I can’t seem to find a simple solution… I created a Form to display the record details of a Query. I have four command buttons (First Record, Next Record, Prev Record, Last Record) to scroll through the records. The problem is when the EOF is...

Hello, I created a Tabular Form (called TabRecordForm) which consists of seven columns of data. I locked the last six columns so that the only column the user can modify is a check-box field in the first column. The idea is the user checks the records he wants to display and then clicks a...

I created a Form which I want to open with one of four different filters (depending on how I want the data to be sorted). I also created a generic filter (called ‘FilterForm‘) which I will always use to open the Form. I want to create a Module to replace FilterForm with one of the four sort...

Hello, I created a Form to add records to a Table (Data Mode = 'Add'). After I open the Form (using the 'OpenForm' command) I intialize several fields and I have a 'SaveRecord' Command Button to save the records. My problem is if a user opens the Form and then immediately exits (using the...

I created a simple update query which I run from a command button on a form. When I click on the button I get prompted by two Access msgboxes saying that I am about to update records and I have to click 'Yes' on both msgboxes before the query runs (which is rather annoying). Is it possible to...

I have a ComboBox on a form which shows a list of valid names. After a name is selected I run a Macro (using the ‘AfterUpdate’ option) which in turn passes the name to a Module for further processing. If a name is selected from the list everything works fine but I have some users who use the...

I have a 25,000 record Table with a key. I am familiar with the MoveFirst, MoveNext, etc. commands but cannot seem to find any infomation which will tell me how to read a Table by the key - a ‘MoveKey’ command if you will. Rather than reading through all 25,000 records with the MoveNext...

I am familiar with the ‘UCase’ keyword to convert a string to uppercase in a Module but I cannot seem to find a keyword to make a string Bold or Italics. Is there a way I can make a string both Bold and Italicized in a Module - Bold/Italicized? Thank you.

I wrote a Macro which passes seven parameters to a Module. The Module simply takes these parameters and writes a record to a table. The problem is the Module is being executed two times, the first time writes a new record to the table and the second pass gives me a ‘duplicate key’ error. There...

Hello, I wrote a simple Module to update records in a table (called 'Labeldata') and it worked perfectly. However, we recently converted this Access table to a MySQL table (with identical data structure) and now my Module does not work. We also installed ODBC on my PC. Below is a copy of the...