Recent content by abujafar

I will. Thanks I really appreciate the assistance. One quick question though, do you know if access automaticcally inserts a related record for subforms. I am trying to figure out why access is saying there is a related record for a record i just started adding.

This is weird. I just changed the command from cancel update to delete and it caused an error that said the record cannot be deleted because there is a related record in payroll. Payroll is a related many side table that is attached as a subform. There is actually no records in there because the...

No I am not using transactions. No I do not now when I can no longer undo a record.

The code is giving me hell I have some buttons on a subform I am using to control a parent form. I am trying to write code to cancel a new record. The cancelupdate and moveprevious methods do not seem to work. After I click cancel the new record still exist and it does not move to the...

Its for a small company that I work for and it is not in the US, So the tax calculations are different. They requested for me to do it in Access.

I have a Salary table(The one side) and a Deductions table(The Many side). Whenever the salary is entered I want to calculate and store the deductions in the deductions table. I know calculations should be done in queries but I want to store the calculated deductions because the tax system...

Thanks A lot Guus2005

In the following table I want to produce a crosstab query in access 2003 that will use the products values as the column headings. However I want condiments to display instead of pimento and cinnamon in one column, Meat instead of Beef and Chickent and Dairy instead of Milk and Cheese. These...

I am still having problems with this issue. I am seeking an alternative solutions. Anyone knows how to use the IN keyword in Access in Design view. "Not SQL view"

Here is a copy of a similar database. I can't upload the original so I recreated the problem in a simpler database. Thanks in advance

hello every one. I am trying to specify more than one criteria using or on a textbox using query by form. This is pretty urgent. database facts: There are six periods in the school year. I have a checkbox for each period. Whenever a checkbox is clicked that period is added to the textbox. If...

I just completed a database that user meant to be used by one user on a single computer. I was just informed that it will be accessed from a computer on a peer to peer network and will be accessed by multiple users at the same time. I am not accustomed to creating multi user database on a...

Pat Hartman your solution seems to be applicable. I am going to try it in the next couple of hours and let you know. My concern is to produce a report with all the applications for a particular client. An quick solution seems to be a main report with the application info and two sub reports one...

I am unsure about the following situation. In a database there is a client table and an application table for application forms. The Client May have more than one applications. There are two types of applications, app1 and app2 for arguments sake. The applications are the same except for a...