Search results

You can always link on a primary key that is 'invisible' to the user. That way when you need to change tag numbers, the underlying record is still linked to any other tables. For example, use an autonumber field called AnimalID in your main 'cows' table, which is then used as the foreign key...

Glad we could point you in the right direction, and thanks for posting your solution - I am sure others will encounter the same issue.

Here is a very rough database that illustrates the points being made, which may help. It includes a couple of queries, one showing how you can return the value of a particular reading, the previous reading and the difference between the two. This is a very rough hack and you should...

As jzwp22 suggests, you may want to look at a small redesign of your tables, to really take advantage of an access database (which is quite different to a spreadsheet). My first suggestion would be to remove the individual Wells from your table and set up a couple of related tables - one to...

Do you have a reason why you do not want to use a subform? I still think that it will be more efficient for the end-user to enter the information they have, such as a firstname, and see the matching results on the screen so that they can choose the correct record. For example, if 2 Bob Smiths...

I think you may need to rethink your search process. Firstly, the easiest way to have a form display data related to a specific record is to make the form data-bound. That means that every combobox relates to a field in a table. It also means that when you select a value from one combobox you...

It's a fairly easy task to get values from a table using a Recordset. You can then run whatever queries are needed based on the value in your recordset. One way is to modify your stored queries to have a critieria such as [ID], which can be replaced at runtime with the value from your Recordset...

BTW - I used your code on IE 7.0.5730.11 and the URL opened in the new browser every time. There were a number of posts on various sites with similar issues for IE 7 RC1, so you may find you just need to update you IE version.

I would suggest you check the IE settings on the PC that is not opening in the new browser. There are a number of options in Tools/Internet Options/Tabs that might be worth checking. It could be that IE is determining where the new window should open based on these settings.

The syntax works for Access 2000-2003, but you will have to make sure you have referenced DAO (Microsoft DAO 3.6 Object Library). Go to Tools -> References in the VB editor screen.

When you open the datasheet form, use the WHERE clause to filter the results. For example, if the user has the form open where the Asset field is called txtAsset and they press the button labelled List Assets, called cmdListAssets the following code would open the datasheet form called...

Basically you want to add this code to your button. Dim objApp As Object Dim objBook As Object 'create an instance of Excel Set objApp = CreateObject("Excel.Application") 'make Excel visible objApp.Application.Visible = True 'open the require spreadsheet...

If your user choses the serialnumber from a combo box, then you can code the BeforeUpdate event of that combobox to check that the serialnumber has not already been used. In the snippet below I am using a combobox called cboSerialNumber. Private Sub cboSerialNumber_BeforeUpdate(Cancel As...

If the form is unbound, then you will not be prompted to store the combobox value in the database. You can still use the combobox value by using Me.[NameofComboBox] in you VBA code, or as a criteria in your Queries by referrencing the combobox. Just select the 'Build' option from query popup...

You should not find any issue with dates already stored in your database, because it really is only for display purposes.

It is a Windows setting, so it depends on your version, but for XP it is in Start -> Settings -> Control Panel -> Regional and Language Settings. You will need to change the 'Standards and formats' option to a country that supports dd/mm/yyyy - for example UK or Australia.

As David suggested you want to code the AfterUpdate event of the combobox in question. However, I suspect you want to display and hide the textboxes depending on which value the user has selected from the combobox. In this case, you will need an IF or SELECT CASE statement. If me.cboSelected =...

If you have not bound the form to a Record Source you will not be prompted by the wizard to save the value in a field (because it doesn't know what fields you can save to). Make sure your form has a valid Record Source, either a Table or a Query and then add the combobox. If you have already...

The input mask only controls the number and type of characters the user must enter into a field. For example, the date expect 2 digits, 2 digits then 4 digits. The input mask does not know if the first set of two digits represent the month or the day of the month, this is set via the Windows...

If you are using the code by HiTechCoach, then the function GetOpenFile takes an optional parameter that sets the starting folder to browse. So when you call this function from your form, you could set the starting folder to anything you like; strDocPath = GetOpenFile("C:\temp") If you...