Search results

As part of my data structure I have a Fault table, Transaction table & Resolver table. The Resolver's are dependant on the Transaction that are selected in the fault table. What I am after (and it's not happening) is when selecting a Transaction in the Fault table the only resolver that is...

Thanks for the response. I am understanding the logic behind the code and the critieria entry, however, do i use both the code and the criteria in the query grid? What I want to happen is the following: I want the code to execute on an exit event of a text box, so I want the user to be able to...

I am working on a form that will be used to search records in a table. I have created the query shown below: SELECT tblSTC.STC, * FROM tblSTC WHERE (((tblSTC.STC) Like forms!frmsearch!txtsearch)); I want my user to be able to enter search criteria and allow the use of a wildcard. When i run...

I have worked out that the following query should do the job, however it doesn't: SELECT tblSTC.STC, * FROM tblSTC WHERE (((tblSTC.STC) Like forms!frmsearch!txtsearch)); This produces no results ??

This is what I want to do however do not really understand the response. I need to be able to search a table based on the value entered into a text box. However similer to the above problem and need the results to be limited. I have a table with only one field with records that appear like this...

Code stops Access responding. I have now declared the varible. When the code is executed it appears at first glance to work (no error msg's are displayed) however Access stop's responding and I have to 'End Task' to recover. I have tested it on other machines so it's not machine specifc. Has...

This one is seriously confusing me - I am using the following code to append a table in my db. The user enters a number into a text box and the code is designed to append records to the table based on the figure entered. The code doesn't produce any errors when executed however each time Access...

Stressed I'm struggling with this code. Can somebody tell me where I have gone wrong incorprating the code. Private Sub cmdSubmit_Click() Dim a, b As Integer Dim strsql As String If IsNull([cboTeam]) Or IsNull([cboName]) Or IsNull([cboActivity]) Then MsgBox "You have not selected...

I have a number of databases that all export data to Excel spreadsheets. Using the following: DoCmd.OutputTo acOutputTable, "tblFault", acFormatXLS, "G:\\FaultLogReport.xls" Application.FollowHyperlink "G:\FaultLogReport.xls" What i want are the individual databases to export and update the...

I have a form which a user selects an activity from a combo box. On some occasions a user may need to enter the same activity a number of times. I want to add a text box/combo box that a user can enter or select a number. When the user hits the submit button i want the records created in the...

:confused: I have a logon form which works well and authenticates users via a table. The problem is when the form is loaded the user has to click into the text box to type their name. I want a cursor to be flashing in the text box when the form opens so the user can type their name straight away...

Brilliant that works but..... That's great it works now however....The field that the user double clicks to display the record is now populated with ##name? rather than the fault ref. I can't seem to work out how to get it to display the ref no

No, im using an Autonumber in the field. I have tried the code though however i still can't get it to work.

sorry i didn't attach the .mdb, here it is. You will have to launch the database whilst the shift key is pressed down. Many thank

hey, im using Access 2002

Compile error msg Hi, thanks for the advice. I have tried to implement the code however, when i click on the field to execute the on click event i receive the following compile error msg: User defined type not defined. I get the error on the first line of the code.

I have a fault form which the user enters details of a fault. When the fault form is submitted the data is saved in the relevant table and the form is cleared so that the user can enter the next fault. On the fault form i have a subform which displays the faults previously entered by the user. I...

that worked fine, thanks

I have a form with a sub form. The form allows users to enter data into the database and the subform displays all records in the database. I want users to be able to click on one of the records displayed in the subform and that record to display on the form in the format it was entered.

No it's not changing. It just displays: Auto Number