Search results

Greetings, Using Access 2000, I have designed & deployed a server-based database table (Be) in the server and distributed the (Fe) to about 10 – 12 users machine. They start using the database since March and so far entered about 5000 records and there was no problem. One day they entered a...

Greetings, I’ve designed a database consists of a main form and a subform based on tblHeadOfHouseHold and tblApplicants. I’ve also created an audit trial to track down the user name who last modified the record. It works fine in the main form (frmHeadOfHouseHold) and updates the last user...

Greetings, I’ve a DB which is split to BE/FE (be in the server and fe in users Pc) since I want to work on it at home, I first deleted the link and imported the BE to the FE and saved it to my desktop and burn it to a CD. However, when I tried to open it at home from the CD I get the following...

I’ve designed a database consists of a main form and a sub form. I’ve also created an audit trial, to track down the user name who last modified the record. It works fine in record was modified in the main form but in the subform, it only works on one control. Following is the code I used...

export to excel Thank you very much, it is working! DD

Greetings, I’ve designed a database and deployed it without giving users access to the table. I’ve also created a report for them but, their reporting needs vary time-to-time and they want to be able to manipulate the table themselves; what columns they want to include and what columns not to...

Hi, I have a main form (frmHousehold) and a subform (sfrmApplicants). In my subform I have a field called #OfApplicants which will count the number of Applicants in the subform (in the subform I have a hidden control) which works fine. However, I created (PrintRecord) button in the main form...

Hi, I have a situation where two users have the exact same copy of the same database. When they are on the field, one user enters in the SiteID field starting 1000 and the other user enters in the SiteID field starting 2000 in AppData table. My goal is when they come to the office to be...

I have main form along with a subform. In the subform I use the record selector to go to the next record for instance, to add new record. However, even if I do not add a new record and close it, it will assign ID and save it as a new record. Could you please tell me why? Thanks in advance...

Validation rule Hi Pat, I’ve tried the above and got: Compile Error: Expected Function or variable where I have Me.AppDate.SetFocus = True and only when I comment out Me.AppDate.SetFocus = True then it works fine. Thanks, Danny

validation rule Hi, Can you please give me an example how to go about doing this in the form's BeforeUpdate event? I even tried to use validation rule in form's design view, but no success. Thanks, Danny

validation rule Yes, EligDate is in the same table and it's not guaranteed that it will be filled in before the others. Since I wasn't sure how to perform the validation at form level, I was trying to perform it in table level. Just to clarify, the reason EligDate field has to be greater than...

Yes, EligDate is in the same table and it's not guaranteed that it will be filled in before the others. Since I wasn't sure how to perform the validation at form level, I was trying to perform it in table level. Just to clarify, the reason EligDate field has to be greater than other date fields...

I have the following date fields: AppDate, ReassessDate, RedetDate etc. I want these dates to be less than EligDate, so I can put in the Validation text something like 'Date you entered must be less than EligDate...' when the users enter dates greater than EligDate. Thank you in advance! Danny

I have designed a workers productivity report using Acc 2K which is based on a query and the query is based on one table (all the fields I need Workers, EligDays...etc. are in the same table. Each worker has 10 business days to process the application. The way it's determine is I have a field...

find record Greetings, 1. By looking at the property of the subform: Link Child Fields = AppID Link Master Fields = HholdID I assume that they are linked as a master-child. Thanks, DD

1. I tried to use a Find Record button to search for a specific field, e.g. LastName, FirstName etc. I have a form (frmHouseHold) and a subform (sfrmApplicants) and I placed the Find Record button in the main form., searching a field in the main form works fine, but not for the subform. I...

Sorry that i wasn't able to get the attachement. Let's try again! Thanks, DD

Greetings, I have designed a Workers Productivity report based on a crosstab query to track how many applications the workers processed within 10 business days(<=10) and how many over 10 business days (>10) for the Fiscal Year. 1. How do I get a total for each Workers each Month? For...

Greetings, I have design a report to determine the total # of applicants in a given fiscal year. When the user clicks on “Fiscal Year Report” the following dialog box will appear, and the user can also change the dates for a desire year. Start Fiscal Year: 01/07/02 End Fiscal Year: 06/30/03...