Search results

Hi I have a text box bound to a field in a table, now ive noticed boxes appearing at the end of some lines (where i think users are pressing enter or shift+enter) in the text box its kinda like [] now when i run a query on this table it does not output the full number of records i think it does...

Hi I have a make table query which has a date field within, the criteria is Between [Enter Start Date] and [Enter End Date] what i want is the results of this criteria to be added to the table name i.e Start Date 1/11/04 End Date 30/11/04 run query - Make Table - Save Table with name...

Hi Long time no post, I have form attached, which i want to cycle through all the existing records in the table it is bound to, i then want it to on each existing record automatically drop down the cboEmployee box and select the entry that is already selected and then move on to the next...

the mast table stores each and every record the employee table holds all the employee names with related numbers for manager, department etc.. ive now added three more columns CallsRequiredPM (per month), and CallScreenedMTD (month to date) and FTPT which just says FT or PT Basically each...

Hi, This is possibly a deployment question but my problem is with the form i use to update my FE Client, Ive used some code example from http://www.databasejournal.com/features/msaccess/article.php/3286111 So i have a FE (all forms etc... and a form that calls update.mdb from...

I have a main form and a sub form i have a main table and a sub table the main form is creating a record in main table and then the subform is forced to create a record in the sub table (as they are linked) now whats happening is the main table is opening the record and then the sub form is...

Hi, im having a problem with shring my db over a networkt, as far as i understand access 97 locks a page (2k) of records when a record is being edited, does anyone know a way in 97 how i can get access to lock ONLY the EDITED record and not the page? in Tools/Options/Advanced i have "edited...

Hi, I have a form that is used for data entry each user logs in, creates records and moves on to the next, (the record selectors at the bottom increment +1 each time and the ID (PK) increments to the next available number which is fine, however say a user enters 10 records it locks these 10...

Hi, Ive read through a few of the threads regarding this issue or similar but cant understand most of them , i was wondering if anyone could explain (in a simple format) how i can resolve this issue. im a complete newbie at this thanks i have two tables tblmain frm Main ID(autonumber PK) ID...

Hi, I have a normalised table, however i want a subform in a parent form, that will display historical records based on the agent name selected from a combobox, i can do this via the subform wizard, however the subform brings back data of how it looks in the table (i.e numbers etc..) can...

Subform based on normalised database Hi, I have a normalised table, however i want a subform in a parent form, that will display historical records based on the agent name selected from a combobox, i can do this via the subform wizard, however the subform brings back data of how it looks in...

Hi My db is below http://emotiveexposed.mysite.wanado....co.uk/test.mdb i have a series of checkboxes in sections Compliance and Quality here is my required scenario what i want is if compliance checkbox.value = 1 then flagawarded = "Red Flag" else "n/a" if quality checkbox.value = 1 then...

Hi, I have a form with a subform, i want the subform to show (like a filter) existing records based on a combobox value can someone explain how i can do this please? thanks you

Hi, I have a db that has a sub form, the checkboxes on the sub form give values to parent form textboxes, however on next record the checkboxes have the same value as the last record and do not revert to their default values. these are compliancescore, qualityscore, HSsoundscore...

Hi i have a make table query that outputs a normalised database to text format (bringing linked info from another table) but checkboxes that are 1 on the source table are being output on the new table as -1 anyone know why this is, and how i can fix it? thank you SQL: SELECT [CMS Compliance...

Hi, I have some checkboxes as you can see from the attachment its pretty self explanatory what im trying to acheive. does anyone know of a better way of doing what ive done so far? thank you scott

Hi, I have inserted an activex media player control into a form, but i cant seem to figure out how to get it to ask which file to open? does anyone have an idea or documentation on the properties for this control (its access 97 btw) thank you

Hi, I have a tblMaster and tblScreeningForm and a frmMaster and frmSubMaster tblScreeningForm has questions such as salutation complete? etc... frmMaster has name, dept. etc.. that is stored in tblMaster, what i want is to have a frmSubMaster inside frmMaster as a subform frmSubMaster will...

Hi, I have a db (fiel too big to attach i can email if required) which has three comboboxs which are all related to their relevent tables. i.e Employee combobox links to employee table etc... The question: the three comboboxes output to a table calls CMS Compliance Table, (which is where i...