Search results

I'm currently running Access 2003. My database contains master client records, each of which has as many as three types of child records. My database is set up so that the child records will be deleted if the master is deleted. I have made a query writes out a table containing the ClientID...

All I have is the transaction date. I have to determine the weeks based on Sunday thru Saturday regardless of which day of the week was the first day of the month. I currently pull the data for the month from my transactions table and creating a temporary table to use in generating my report...

I have a report which is run monthly. It is a list of clients for which we have provided services during the previous month and it totals the hours of service per client and at the end of the report. I now need for it to sub-total within each client's transactions for each calendar week during...

It worked like magic! Thanks for the help.

I am working on an employee information database in Access 2003. I have a combo box at the top of my form which is used to select which employee to display. After the selection has been made, I want the combo box to return to being blank (like it is when I first open the form). Currently, the...

Thanks for all of the help. I have found the software I was originally looking for, as well as the AccessImagine. I am trying to avoid using the external links because I don't believe that my users will tolerate all of the steps involved in scanning the documents, placing them in folders...

Now I have lost the url to the web pages for the software. I searched all Friday afternoon and have started again this morning. Does anyone know where I can find the software? Thanks. Cherry

Has anyone used DPix Image Control to place images in an Access table? I found the software on the Microsoft Marketplace. But before I buy it, I would like to hear from someone who has actually used it. Thanks, Cherry

I have searched this forum and found (and tried) a number of examples of similar problems, but they have not worked for me. I am running out of time. I have a date field (HireDate). I need to look at the month part of that field and pull the matches for the current month and the next two...

Thank you! Thank you! Thank you! It made no sense to me, but I'm not knowledgable in that area.

If you have done this, please tell me how. Both the frontend and backend are in Access, but my network guy wants me to connect them via a SQL ODBC driver instead of just linking them the regular way. I've tried everything I can think of with no luck. Thanks for any help you can offer. Cherry

The back-end (no pun intended) is about 250 meg. when compacted. We have about 6-7 users who use it all day long and another 2-3 who use it occasionally. But I still don't understand the logic of not converting the backend to SQL and simply using the SQL ODBC driver. Does this make sense...

I have a very large Access database. It is separated into a front-end which contains the forms, reports, queries, etc., and a back-end which contains only tables. I am told that the back-end has grown too large for Access to handle it and that we have reached the limit that Access will allow...

Thanks for the suggestion. I will give it a try.

It has been several months since I made the attempt, but as I recall, I had a little VB procedure that looked at the voucher field. If that field was empty, all of the fields were editable. If there was something in that field, then all of the fields in the record were locked. The result was...

I have a continuous form. One of the fields is for a voucher number. I need to be able to prevent changes to any record that has something in that voucher number field while allowing edits to records with a blank voucher field. What I have tried so far locks all of the records. Is what I am...

Thanks! Once I thought about it, it was so obvious, but I had been racking my brains!

I need to prevent my users from deleting records displayed in a query. My first thought is to remove the record selectors at the left side of the display. Is there any way to do that? Thanks. Cherry

I have a report where the report header contains a total number for each type of service that we provided. The number of services is calculated from the detail section by using DSum. The number for each type is then multiplied by the rate for that service in another control. My problem is...

Here is my situation. I have a master client form with a subform showing the current and previous programs that client has attended. Clicking on a button located on a specific program line opens a form showing the list of services that client is authorized to receive. Clicking on a button on...