Search results for query: *

I am using an update query in the update event of the text box that contains the number of triggers. when it is changed it kicks off the query. I had tried ado with the same result. The only way to avoid this before was to use unbound controls but then i had to jump through hoops cause i used...

I am also getting a write conflict . I have a main form and a subform. when the main form changes i programmically change the values in the subform on all records. so if i have a main form and 3 records on the subform i change all 4 records. when i click on the main form i am fine. as soon as I...

I am using office xp with windows 2000

It's nothing like that. I am in design mode. I have a form and a subform. I am tracing them out and need the record sources of the 2 forms. I get confused on the record source of the subform. If i open the subform it says one thing. If i open the main form go to properties then select the...

Thanks. I just seem to be viewing conflicting data. If I use the form selector on the main form right click and select properties i get a form . If I scroll down through the selection box at the top through the controls on the form and when i get to the subform and select data tab, It shows the...

I have some forms that have subforms. What is the correct way to determine the record source of a subform. Can i select properties on the main form, scroll down to the subform name select it and find the record soure under properties or do i need to open the subform independently. Thanks. lewie

Hello, I need to get a field from an oracle db for a form i have in access. I tried loading client 9I but it keeps getting to the point where it asks what type of installation and i have tried all 3 custom, client, admin and after it loads 33% it doesn't do anything else. Any help would be...

Thanks a bunch. It worked perfectly

I have a report and I would like to place a list of affected areas at the top of the report. These would be one field from the query. So #1 do i need a subreport in the header and #2 how do i make a report list the names on a line one right after the other. not one record per line. You'll have...

The parens didn't help. I ended up assigning a ctl var. Dim ctl As Control Dim big As String Set frm = Forms("form1") ' Dim endoffile As Integer ' Dim x As Integer ' On Error GoTo HandleErrors Set rst = New ADODB.Recordset rst.Open "main", CurrentProject.Connection...

Thats where i got to but it doesn't like the quotes. is there a type of variable i could assign it to so the quotes wouldn't be there. form_form1.btn_1.caption gets me what i want but when i make a string var and assign dim var as string var = "btn_"&ID when i sub the var in form!var.caption...

I numbered my buttons btn_1 btn_2 ect. I was wondering how to loop through them using a for loop. i have tried the below but keep getting errors: Private Sub Form_Open(Cancel As Integer) Dim rst As ADODB.Recordset Dim ID As Integer Dim big As Field ' Dim endoffile As Integer '...

thanks again. you know what works screen.activecontrol.caption i stumbled across something close in my cookbook. Thanks again for the help lewie

Thanks for the quick answer. what i want is to extract the caption of the currently selected button and pass it to a query. forms!myform!currentbutton.caption is there any such syntax to extract the caption from the currently selected button. forms!myform!btn_1.caption will give me the caption...

When I click on a button I want to run a query which will use the current buttons name or caption in it's criteria section. I can do it for a button. How do i do it for the currently selected button. Thanks Lewie

I have a form i want to use to look up records. I need the form to contain info on 20 records that can change. Each record could be a state with info about the state. This info needs to be represented in some nature such as a button with a name on it. ie Alabama. I need the name to be editable...

I want to make a main form with buttons on it and each button brings up a record. I want the caption on the button to be the name field in the record it brings up. So i essentially need to alter the caption property of a button based on a field in a table. Please Help... Thanks Lewie

I have a text field with name address city ect. I am extracting the pieces and building a new table with name, address, city state, zip fields. I loaded the first line in to fname and lname what code to i use to start at the second line so i can read that. is it chr(13) and Chr(10) but how do i...

I have the following code: Public Sub ExportADOXML(strTableName As String, f As String) ' Export the specified table as XML, using the ' ADO XML format rather than native Access format Dim rst As ADODB.Recordset On Error GoTo HandleErr Stop Set rst = New...

I am new to vb. I have a shipping form with a combo box for contacts. When a selection is made I want to fill in the information for a contact from a contact table into the forms text boxes. I can do it with an update query but then I have to requery to get it to show up and I don't feel like I...