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...

what i would like is either: for the make table query to prompt the user for a new table name i.e run qry - Prompt for Date to and from - prompt for table name - make table or for the table to be made but using the returned data from the date criteria prompt as the new table name i.e run qry -...

thanks for the reply, i need seperate tables as i have pivot table reports connected to the table, each time i run the query it overwrites the table and thus the pivot table

or even get access to prompt for a table name each time its run

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...

Colin, thanks i feared this how would i structure this ive attached my FE for you to see my current structure

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...

thanks for your hlpe, ive resolved this problem by first storing the values on the main for that the subform changes in an unbound textbox and then before save record i copy these values to the bound textboxes bound to the main table

Pat, thank you for your advice, can you recommend a structure for it? shall i create just one main table to hold all values from both the subform and the main form or is there another way? thank you Scott

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...

db attached

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...

ok answering my own question again :-p Me.frmAgentHistory.LinkMasterFields = Me.cboEmployee.Column(2) Me.frmAgentHistory.LinkChildFields = Forms!frmAgentHistory.EmployeeName frmagenthistory is based on my normalised table so the subform is now showing the data in text format which is...

Ok ive done the SQL query that brings the data together so i now have a table that is an output of that query, this is fine so on creating a subform and matching the parentlink to childlink it says this table has "agent name" as Long integer what i need to do is on my form after each time an...

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...