Thanks so much for giving a time to help. The Overtime field is a part of a main form which is bound to a primary table named tblEmpData. The HoursTotal and...
I need to know the name of the subform control (not the form inside the subform control - though they may be the same) to solve your problem. John Viescas,...
The name of the Subform control is DailyRosterSub. ... the ... problem. ... main ... so ... this ... SQL. ... message. ... the ... HoursTotal ... Charles" ... ...
hello It is an Accounting software in Access. in main table i have entered still 3-months date wise which has round about 4-thousand enteries every month. In...
In both the Current event of the outer form and the AfterUpdate event of Overtime control, put this code: Me.DailyRosterSub.Form!HoursTotal.Enabled =...
If you are missing some of the dates, the problem must be in your query for the report. It might be the type of join if more than one table is used. Missing...
Im sure this is a simple question, but its the first time im trying it. im trying to access a sql server from access, so i linked the tables through odbc, used...
Karl- When you link the tables, you must tell Access the Primary Key. Some tables containing floating point numbers or memo/hyperlink fields will also update ...
You need to think vertically instead of horizontally. Suppose you have your User data table (I'll call it tblUsers) looks like this: UserID UserLastName...
thanks, i did do that, and it didnt work. but i did solve it, apparently you have to also check "remember login". ill bet it defaults to a guest user when the...
If you are on a Microsoft network, I suggest you use NT authentication. That way the users won't have to fiddle around with logins. Regards, Bill Mosca Founder...
I know this question is simple for you but since I'm a beginner, it's hard for me. I have a "SHOP DWG" form with a "DWG NO" field in it. I want to make sure...
Hi guys, does anyone know how to round off numbers to the quarter of an hour Ie start time to finish time = ... I guess if its 9.05 it should be round down to...
Is the "DWG NO" a simple number, or is it letters and numbers? If it is numbers, do they need to be consecutive? John Viescas, author "Microsoft Office Access...
What data type are you using to store this time value? John Viescas, author "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL...
I already made this option as indexed (YES) no duplicate but still Everytime I make an input of new record, and make an instance of one record, As I go to...
Hello Everyone, I'm brand new to Access... new to databases period, but I have a very important project I need to complete. I am a Paramedic and we want to ...
What defines a unique record? is it a group of fields like FirstName AND LastName. If so, you have to create an index using BOTH fields. Open the table in...
Nick- First, Access is absolutely the right tool for the job. Unfortunately, you cannot just "jump in" to Access like you can with Word or Excel and start ...
Hello John, ... I'm using Access 2002. I know I'm rushing things a little... wanting to immediately start data input, but as you mentioned I have to start ...
Hello Bill, ... Thanks Bill for the links... Good advice I'm sure, and I will start that very process right now. :o) Really appreciate the help from you and...
Nick- Take a look at the Service Call Management database Wizard. It'll set up tables for "Customer" (the people you serve), "Work Orders" (one of your ...
Hello John Viescas, ... Ok, I will do that. ... Thank you very much... ... I'm running Access 2002 but I will keep an eye out for the above. ... Okay, I will...
Nick- ... Very little changed from Access 2002 to 2003, so the Inside Out book will be more suited to your needs once you get to that level. John Viescas,...
OK. Is it hours and fractions of an hour, or do you do special math on it to store seconds in the fractional part? If it's fractions of an hour, then you...
I am in the process of setting up a database for a church directory. My table: Mbirthday Fbirthday child1bd child2bd.... When I try to query each field for the...
Well, first your table design includes a repeating group - each birthday should be in its own row, not a column. Let's say you have columns for up to 4...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
