Search results

I have a table that has among others 4 fields that record whether or not an type of incident occured by use of a checkbox (I coulnt use a list because more than once type of incident can occur in a record). Incitype1 Incitype2 Incitype3 Incitype4 Record1 Y...

I have created an adobe acrobat form and would like to load the responses directly to Access or even through Excel. Anyone tried this?

When it comes to data entry, do I enter the data into my incidents table and then again into the juction table to specify which species the incident is associated with? If I am not recording any other info about the species in the Species table apart from IDs and names, does creating three...

Whenever I try to compact my database or save a new query, I get a message "The search key was not found in any record." Any idea what Access 2002 is talking about here?

I am preparing a database for reporting wildlife incidents. Some of the data I will be entering in this database include the type of incident (there are basically three types we record) and the animal species involved (there are several species). Since the three incident types will be repeated...

Just wondering, is it possible to include a code that would make the Access application window hidden when the project starts? All I am able to see is hiding the database window. I would like my susers to interract with the forms only without seeing the main application window. Nasser

Yes I managed to solve that. Thanks. I used this, not sure how efficient but it works. The problem is that when any value is missing (Null) from the field that I'm populating from, it gives me an error. No idea how to sort that. Also, how can I ensure that it only displays unique values in...

Strangely, this is not working for me in Access 2000. I get an 'Invalid procedure call or argument'. I tried it out in VB 6 and it works fine and actually it looks very right. Me.txtSample.SelStart always evaluates to 0 when I debug, regardless of whats selected or the position of the cursor.

Sounds simple but I'm stuck: I'm working with two forms. I need to refresh an activeX control in FORM1 by using an even (eg click) in FORM2. How do I reference the control in another form? Nasser

Well it doest populate with the 'fields. Private Sub lstTableNames_AfterUpdate() Me.lstColumnNames.RowSource = Me.lstTableNames Me.lstColumnNames.Requery End Sub in this, I assume you meant lstNames is the first listbox while lstTableNames is the second one and that's how I used it...

Any new ideas here?? still wondering how to make .openrecordset work in Access 2000

Yes Selstart should do that. Relatedly, how would you insert text at the location of the cursor by using code? (not at the end of the existing text)

Thanks Pat but what this does is that it populates my first listbox with the names of all the tables in the database (except system tables) and when I click on the listbox, it adds the name of the table selected from FIRST listbox to the SECOND listbox. However, what I want is that it populates...

I am beginner in Access programming. I have two queries: 1. I have two list boxes and one is populated with names of fields from a table within the access database. I would like to click on the first listbox (lstFields) and the values of the records in that field are added to the second list...