Search results

Sorry.. Over complicating the matter. Sorted it. Private Sub cmbProvider_AfterUpdate() intvalue = Me.cmbProvider strSql = "SELECT distinct(Location.Address1), Location.LocationId FROM Location INNER JOIN (Provider INNER JOIN ProvLoc ON Provider.ProviderId = ProvLoc.ProviderId) ON...

Hi im trying to repopulate a combo box based on the selection of a value of another combo box. This is where i am so far. Am i going about it at all in the right way? The error i am receiving is "syntax error. in query expression" Private Sub cmbProvider_AfterUpdate() intvalue =...

Thanks for that. This works if i have the default view set to single form. However when i switch it to continuous forms then either all the checkboxes are ticked or none of them are ticked. This seems to be dependent on the value of the first record.

Hi. I have a form that retrieves a number of records from a query based on a filter. I then have a checkbox that i would like to be checked or unchecked based on the value of one of the attributes in the returned recordset. I was wondering how this could be done? Thanks

I have a form where a user can select from two combo boxes and the values will be inserted into a table. However before the insert takes place i want to check if a record already containing the two values already exists e.g values selected in form combo1 = 1 combo2 = 1 table combo1 = col1...

Hi I have an text box with an input mask of >???????? to convert the text entered to capitals 1. Are there any other ways to convert to capitals? 2. With the way i have done the input mask if you click anywhere in the text box the curser starts from there. I would prefer it if no matter where...

Variables Well what id like to do.. (probably not the correct way) I have a custom password form that allows access to three different forms. However if a user comes out of one form and wants to access another then they are prompted for the password again. I would like to store the password...

Hi can anyone tell me if there is a way to store something in a variable for a particular amount of time or until an event occurs. e.g. how would i store a value a user inputs into a textbox for say 5 minutes and then after 5 minutes the variable will become empty again ? Thanks

I have three command buttons which when clicked on open different forms. These forms are first password protected with a custom password form I would like to implement a function so that if the incorrect password is typed in 3 times then it does something like exits the program. Can anyone help...

The form is an add user form and you are presented with a blank text box. if the text box is emtpy and cancel cmd is clicked i want to have option of closing. if text box is not empty then i want to have option of closing or emptying the field to start again. i do this using undo cmd. However...

Hi, I have a front end that i have developed in access which manipulates a table stored in an oracle database. I have an ODBC connection to the oracle table. When i open the access front end i am confronted with the Oracle ODBC Driver Connect and am promted for username, service name and...

Hi I have a combo box and its row source is a query that selects distinct values from a column in a table However i would also like the user to be able to select nothing/null value from the combo box. How do i do this. Thanks

Thanks i will try that. It's case sensitive because i am building a front end in access that links to a table in oracle

Hi I have a form that searches for a match to what is put in a text box. I have something along the lines of this as the main sql statement Select * from Qry_Filter where "[USERNAME] LIKE """ & txt_UserName & "*""" It works fine however it is case sensitive so if i input something all lower...

Hi. This might be a silly question but i have noticed that in the automatically generated code when a switchboard created there are lots of references to Me Eg. Me.FilterOn = True And Many example i see on the web contain this reference to 'Me' I was just wondering what this meant ? Thanks

Hi. I have a form that is used to add data to a table. The txt boxes are bound and i have set the form property of data entry to yes. This all works fine however if i enter a some data into one of the text boxes but then delete it and close the form. it inserts a record full of nulls into my...

HI I have created a custom form for adding a new record into a table. it works aslong as all the fields are filled out. however if a field is left out which is a possibility then it doesnt like the null and errors. I am new to vba and would like to know if anyone help me so that it does not...

Hi. I have a report that is grouped by month. (Month_Id) In every group.month there is a formula which creates a percentage based on some figures in the group. The report is based on a table that is updated monthly In the report header i would like to display the latest percentage figure. for...