Search results

Hi, I am in the process of cleaning up my code as it has been a bit buggy to say the least :( . Currently I am using error handling for some of my subs, although I have read pretty much everywhere that it should be in all subs. As I have many subs per form, would it be wise to call error...

Hi I have a custom login screen created for my database and a table with access levels for different users. I am trying to assign user permissions so that certain buttons on the switchboard are visible/not visible dependent on the user security level. As the login screen and the switchboard are...

Hi I want to create a text box on my Mainform with a list of StudyNumber values from the subform. The subform can contain many records. Putting the following into the source for the textbox: =[Subform].[Form]![StudyNumber] gives me only the first subform recordset. Is there a way that I can...

Hi I have a field in a subform that contains a primary key. When entering duplicate value, I want to be able to display a custom message and display the original entry value. So far I've modified some code from msdn to get the following Private Sub Form_Error(DataErr As Integer, Response As...

Hi All Been having trouble setting up a combo box in a form that displays data from the same line in the table into a text box. I am trying this with a memo field without any luck. I am using a 2 column query for the combo box, the first column contains the name and the second contains the...

Hi all, I have a form that records a unique number which requires a full stop to be present. Is there anyway of ensuring a user has to enter a "." somewhere in this box? Cheers:p

Hi I Have a form with Order# that is attached to a subform with multiple subOrder Numbers. On completion of the order, I send a confirmation email that details the Order number, I would like to also add a list of the subOrder numbers as well- but I'm having a problem referencing them. Can...

I have a query that uses a linked table from an external database and joins it with a table from my database to return records that contain the same values. Is there a way to return only the records that are present in the external database and not in my db? Thanks

hi Ive been using the following code to zoom on a text box as posted by ghudson: DoCmd.RunCommand acCmdZoomBox The problem is it works fine on my PC but not on any of my colleagues, even if logged on as admin. Can anyone suggest any reason why this would not work. It doesnt come up...

Hi, I'm trying to write a simple update vb code for showing/hiding a text box dependent on whether any values are present in subforms: Private Sub Form_Current() If Not IsNull(Me.tbComments) Then Me.LblComments.Visible = True 'shows Comments label when comments box is...

Does anyone know if the command buttons in access 97 forms can be changed? thanks

Hi I need to send an email order confirmation for when an order is completed to only a handful of people. From the way that my tables have been setup, I cannot add email addresses against people names. I have had a trawl through the excellent archive in this forum and am trying to use the...

Hi I have access 97 and I need to find if there is a way to keep a track of changes made in data entry and if you can identify who input the message thanks

I need to find a way to not allow users to access the backend by using the database window. Is there a way I can password protect this? Thanks

Hi I'm trying to use an access 97 database that I've created but there has been some problem with saved information being lost. when I go to save updates to the form I get the following message "Form has been changed since the last time you opened it, either by another user or because another...

I'm having a problem updating a form. The query from the form is based on two other queries, one of these queries is based on a table from an external database. I want to use the Form to populate only data on my own database using a checkbox with: If IsNull (Me.ReceiptDate) Then ReceiptDate=...

Hi I'm a definite Newbie for coding (as you'll see in the example below) I am simply trying to get an output into a Label when certain criteria are met in a form. However, the code below does not work and I can't figure out why: Option Compare Database Option Explicit Private Sub...

Can someone please help with the following: I am trying to join two tables in a query. One of the tables has only the fullname while another has only the surname (this table is imported from an external database). I need to be able to match the two tables up. Can anyone please suggest how to do...