Search results

Hi, I have a report that diplays info on a single person. It has a parameter of 'Person ID'. I also have a continuous form which displays a list of people from the database with a command button on each row for each person. I want to be able to click on the command button on a single row...

I have developed an access app on my C: drive. I have set up user and group accounts, passwords and permissions so that users could not view form design or table design etc. I then copied the mdb to the server, got a user to log in from another PC and they were just allowed straight in, not...

Cheers, At first I tried it with a text box and set the DefaultValue property on the mouse move event, I have now changed it to be a label caption property on the mouse move event. But it is still flickery when you move the mouse. Is there a way this can be stopped? Cheers

Hi, I have several command buttons on a form which each run a separate report. I then have a text box to display a description of each report (as attached image) What I want is for the text within the text box to change depending on which command button the user rolls over, but when the...

Genius! I knew that function existed in 2003 but could never find it in 2007! Here you go... Look in the VBA of 'frmSearchChildResults'. Thats where the function I posted is. Foxy

How do I upload my stripped out db? Even when I zip it up its still 4MB big, and the limit is ~700k!

Yea, I'll have a go at stripping it down and posting. I have a star at the end of the 'Select' line on the record source to return all fields from the table. The first part is just to concatenate the forename and surname. strRecSource = "SELECT tblchild.forename & ' ' & tblchild.surname AS...

Not really I'm afraid mate. I dont mean to be a pain but it has sensitive child data in it. In the function I posted, all the record sources work and the search works fine. It is just that if there are no records returned, the visible properties do not change as I would expect. Am I...

OK, I now have the following VBA code on the Load event of my 'frmSearchChildResults' form: Private Sub Form_Load() Dim strRecSource As String If IsNull([Forms]![frmSearchChild]![txtcypdref]) Or [Forms]![frmSearchChild]![txtcypdref] = "" Then strRecSource = "SELECT tblchild.forename & '...

At the minute I simply have this code in the search results form: Private Sub Form_Load() If IsNull(Me.child_ID) Then Me.Label54.Visible = True Me.Label44.Visible = False Me.Label45.Visible = False Me.Label47.Visible = False Else Me.Label54.Visible = False...

That works perfectly thanks very much! I've only used a dlookup for an ID number before so didnt even think to put string quotes around it. Cheers

Hi, I have a DLookup that has multiple criteria in order to check whether a person already exists in the database when a user enter theyre details. The code I have is as follows: Private Sub cmdSave_Click() Dim SaveResponse As Integer SaveResponse = MsgBox("Are you sure you wish to save...

Hi, I have an unbound for that the user enters search criteria into and clicks on a search command. This command then runs some VBA which opens the second form with a SQL statement RecordSource based on the search criteria. The RecordSource is set in the VBA of the first form. I want to be...

I am using 07 but it is likely that some of the users will be on 03.

Hi, I want to be able to set up user accounts for my access application. I need to have 2 admin users that have access to everything (table & form design, vba code etc). Then I also need about 4 general users that can only view forms, click command buttons etc. I cannot have the users having...

Thanks very much.

What is the vb command to exit the MS Access application? Cheers Foxy

That worked perfectly. Thanks very much!

How would I go about doing that? Cheers

Hi, I have an unbound form in Access 2007, where the users have to enter person details and then also an alternate ID from another source system in a free text box. When they click save it runs a DoCmd.RunSQL INSERT INTO statement and commits the data to the table. How can I get it to...