Search results

thanks for the response pat. i thought about using '0' as the default value, but unfortunately i'm afraid it would hurt more than help. the values for this field (text box) are measured, so i don't want to give the illusion that the user took a reading from the monitor and the value was '0'...

Thanks for the response alan. you post makes complete sense and gave myself a big DUH for not thinking of that, but when i tried to implement it and got the "too complicated expression...." error dialog box. i usually see this when trying to pass a numeric value in an expression requiring a...

hello everyone, i have a formatting question i was hoping someone could help me with. i have a couple fields in my table which are of numeric type with data validation ranges assigned to them. the problem is this data is taken during 2 different shifts: night and day. sometimes only the...

a simple way to do this is create a NewRecord command button using the command button wizard. go to the forms properties (double click on the upper left hand corner box of the form) and select the On Open event. Find the code fo the NewRecord command button and copy this code (Ctrl+C) and...

you could create a save command button using the methods you performed to create the Open Report command button (i.e. command button wizard). or you could create a command button that refreshes the form's data using the same process. or you could add a procedure to the OpenReport procedure...

hi all, i know i should probably know this but my mind is blanking. i have an entry form with a print command button on it. what i would like to do is have the user click the button and access print the current record displayed. currently, when the user clicks the button it prints all of the...

i'm not sure if i'm understanding your question correctly, but you might want to use the ampersand "&" wildcard to concatenate the 2 fields you want together, however you can't add calculated fields to tables. you'd need to do this in a query or directly in a calculated control on a form. you...

thanks for the responses crstphr2 and Pat. i think slowly this many-to-many thing is starting to sink in. also thanks for the responses about the lookup fields Pat, i think i'm starting to realize that tables should strictly be used for data storage and referential integrity. if i'm...

i was wondering what folks thoughts were on an end-all, know-all book on SQL. a book that includes a lot of advanced techniques and can be used as a good reference manual. thanks

i guess i was confused about your original post. in the case that you have a predefined txt file that you just want to pull the information in, you should follow bjackson's suggest of linking Access to the file. I was thinking you wanted to pull all of the information from the txt file into a...

thanks for the response, pat it is quite informative. i'm still a little unclear about many-to-many relationships. using your example i was thinking that to relate students to classes it would be a one-to-many relationship. so that 1 student can be enrolled in several classes. i guess i'm...

if you're looking for a simple non-automated approach. you might try adding a hyperlink to the form with a URL to the txt file on the internet. create a memo field named comments in the forms underlying RecordSource and place a memo control in the form. then have the user copy and paste the...

hey folks, i'm have some questions about relationships in tables and setting up joins in queries: A. when do you need compound primary keys. if i'm using autonumber fields for my primary keys for all of my tables and then have a table that brings in information from more than one table i was...

i just realized i forgot to thank everyone for their wonderful responses to my question. thanks again all.

many thanks again for the response dbalargin.

thanks for the response dbalargin. any insight on my form based on a query question? thanks again

is it possible to alter the RecordSource on a form or report while in the design view of the form or report? what i mean is when i create a form with bound controls based on a table using the form wizard and then i realize that i forgot to add a field or two while working thru the wizard and i...

hello everyone, i have a quick question. i'm working with a relational dbase where my primary key for my main table (ReqSource) is based on 2 fields: ReqID and ESourceID. each of those fields are primary keys (child fields?) to 2 other tables which form a relationship with my main table...

hi everyone, i have 3 quick questions. they all relate to unbound calculated controls (text boxes) on a form. i have a form with a section that looks similar to a spreadsheet. there are 3 columns (controls) and the first two are bound text boxes. the third column is a calculated control...

if you want to display a single record in form view, design the form in "columnar" format. if you want to display a specific record upon opening the form you need to write code onto the "On Open" event for the form's properties. base that code on the criteria your using to find the specific...