Search results for query: *

Is it possible to set the contents of one dropdown based on another. i.e. populating a second dropdown based on the selection made in the first?

I am trying to create a form that will accept multiple search criteria using the following SQL statement. However I am not sure of the SQl or how to create the form. Any help/tips/divine intervention appreciated. The idea is that the form will select records on one or more of the parameters...

Can any one point me in the right direction for tutorials on word templates. What i am tryin gto do is create an appplication that will drop text typed into a TextBox into the desired feild in a word template. Forstly is this possible, secondly where should I start looking for examples...

I have taken this code and tried to modify for a small project. I am not a VBA wizard and have come unstuck. The following code produces a compile error "type mismatch" - I don't know what that means, could someone please enlighten me and suggest a solution. This seems to be the...

I have taken this code and tried to modify for a small project. I am not a VBA wizard and have come unstuck. The following code produces a compile error "type mismatch" - I don't know what that means, could someone please enlighten me and suggest a solution. This seems to be the...

Pls excuse xpost on Access Modules but not sure where to go for this one:) Is it possible to set up a form in word and then ,collate all information into access. I am pretty new at this but feel sure it can be done. Just not sure how to start. How do you set fields as named text inputs in...

Is it possible to set up a form in word and then ,collate all information into access. I am pretty new at this but feel sure it can be done. Just not sure how to start. How do you set fields as named text inputs? How do you export them into Access? Any tutorials ,or tech notes would be great...

is it possible to keep the unique ID of a record in a form when a sub form is called via command button and then insert automatically the original unique ID from the referring form in the table that populates the subform when an addition is made. sounds complicated, probably coz I am not...

I have a form that has a sub form linked by companyName, what I would like to do is get the sub form (notes) to automatically store the company name of the referring record. I am just starting on the path to VBA so am not quite clear what to do. I think I should be using the child/parent...

I have a form that shows the details of contracts based on a relationship to a company name. I have a report that prints all the contracts in the system, I would like to have a uttom that will produce a report based on the company selected and the contracts shown for that company. Any...

I have a form that I would like to view as a datasheet. I have a button from the menu that calls the form, once clicked it comes up fine except that it is normal form view not datasheet. I have set the defalut view property to datasheet, but it doesn't seem to want to know.... What am I doing...

Is it possible to open up a form in datasheet view, i.e. no grey bars anyway - just like an Excel spreadsheet? Tks

Are there any good resources/tutorials covering Excel spreadsheets linked to and updatable by Access (both 97 versions) TIA

I have a smallish database of about 3500 records, school names. I have a 'go to and find' combo which throws an error every time you search for a school beginning with 'St' as in abreviated 'Saint'. Runtime error '3077'; syntax error (missing operator) in expression. Code:- Option Compare...

Any good resources for enthusiastic beginners? Is UML a good place to start for small database projects? Any thoughts on best practice? Are there any tutorials recommended? Any help appreciated.

I am trying to build a query form that searches for a close match, am using the following code, it pops up the parameter prompt but doesn't return any results.... SELECT * FROM CompanyContacts WHERE CompanyName LIKE Forms![CompanyContacts]![CompanySearch];

database architecture, any good resources? I have a project where I am consolidating several databases into one. there is much territorial p**sing going on about 'messing with my database' and 'losing functionality' etc etc. wondered if it is possible to run several different 'front ends' from...

is it possible to the query by form method of searching for records to produce a report. i.e. query by report where the criteria are user inputs. any resources suggestions?

Found the following tutorial about Queries by Form: http://ittcsrvr.bham.ac.uk/ittc/Documents/Access/AccWordDocs/acc0006.doc regards

I have a column, that contains up to three words/phrases seperated by a comma. I would like to count the number of times a record containing a certain word occurs. I think i should be using the inSTr function but am not sure quite how - as i have never used it before and only found out existed...