Search results

Hi, I have a text box on a form. When anyone types into it, it changes what they have typed into proper case. Is there any way I can stop this? The data that they are entering does not lend itself to proper case. There is no vba attached to the text box so the text box is definitely doing this...

Hi, I have a form (continuous) that shows several records, each in an individual detail row. Depending on a value in each of the detail rows, I want to display a specific label and hide others. This needs to evaluate for each separate detail row. This is the code I have. Private Sub...

Hi All, I am trying to implement a user login by using a dlookup against a table called tblUser. The concept is that if the password entered into the text box matches the password in the table WHERE the username matches the username in the table and the active yes/no field is true then it...

Hi everyone. I have a number field in my table that contains numbers 1, 2, 3, 4, and also blanks. I am writing a query from the table as I dont want to see the rows that have a value of '1' in that field. When I write the following selection criteria... WHERE [table].[field] <> 1 The...

Hi All, I am trying to use the UNION ALL syntax in a vba DoCmd.RunSQL function. The following syntax works fine if I use it in a query design window, but I need the code to be in vba. When I run the following code I get an error that says "Syntax error (missing operator) in query...

Hi all, I have a report based on a UNION ALL query. One of the criteria in the query is as follows: (tblClosure.close_date>=[Date From (dd/mm/yyyy)] And tblClosure.close_date<=[Date To (dd/mm/yyyy)]) This query works fine if I run it in its own right, the user is pormpted to enter a date...

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

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

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

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

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

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

Hi, I want to be able to hide the toolbars and ribbon for users accessing my db so that they can only use it as I intended, as an app. However when I click the Office Button in Access 2007 and go to Access Options > Current Database > Ribbon and Toolbar Options and I turn off 'Allow Full...

How do I create a rectangle with rounded corners on a form? Cheers

Hi, I have a form that has unbound text boxes on it. How can I hide a section of the form until the user checks a box? When the user checks a box I want the hidden text boxes to appear, much like a cascading web form. Cheers

Hi, I am trying to update a date field in a table with a sql dateadd based on another date field in the same table. I have it within a RunSQL statement. I cannot seem to get the SQL DATEADD function to workl within the RunSQL. This is what I have currently: DoCmd.RunSQL "UPDATE tblShields...

Hi, I am trying to write to an ID number to a field using the following SQL: DoCmd.RunSQL "UPDATE tblUser SET sg_id = (SELECT SG_ID FROM tblSource_Group WHERE SG_name = txtSG AND...

Hi, I have a couple of combo boxes on an unbound form. One of the combo boxes just displays a list of everything in one field in a table. I then want the rows available to select in the second box to be filtered by what was selected in the first box. This is the row source I have for...