Search results

Hello! Please be patient as I'm not sure the best way to phrase this question. My client has been using an Access database (split into FE and BE) for several years. The client now wants their own customers to submit data from a PHP powered website directly into the database. The client will...

Thank you - I'll take a look at this.

What kind of problem are you thinking of? The subforms are all based on the same table and they are linked to the main form by the primary key (the assessement ID). All suggestions are appreciated.

There are only 3 users and they all have access to every client. I haven't witnessed the problem. Here is the note I received from my client: "Somehow information entered into one patient's file sometimes ends up in a another patient's file. When we have difficulty getting it to accept what...

Hello - I'm tasked with troubleshooting a database (ACCESS for MS Office 365 with latest updates). The database is split into Front-End/Back-End. The backend resides on a server, each user has a copy of the frontend on their own computers. There are three users each entering data for...

Thank you! You saved me hours!

I think I solved the issue. The entry form contains 4 text boxes for the 4 contacts which MUST be entered into the table. The user cannot leave the form until these four contacts are added. The OnChange event adds the records to tblJob_Contacts. Internal Contact ID are added to one field...

I have a conundrum... My database is tracking Job/Project information. The users must assign the Job Contacts which can be both internal and external (ie: Contracts is a Client Contact, while Engineer is an Internal position).. tblContactTypes which defines each of the 10 types of job...

I have a new client who has asked me to assist in making some changes to a database which was developed in Access 2003. The company is still using 2003 with no plans to upgrade. My computer is running Access 2013. Can anyone provide advice before I start this project? I'd like to avoid...

Is it possible to group a report based on expressions in unbound text boxes? I have dynamic report based on a crosstab query. Since the date ranges can change, the report control source is assigned via VBA as are the column labels and textbox control sources. EE ID AVG FTE Month 1...

Hello All, Perhaps someone can help solve this dilemma: I receive a large flat file from an Rx vendor – from this file I need to be able to run reports based on the Rx name and therapeutic class/subclass. The Rx Names has to be derived from a more detailed field (Label Name) in the vendor’s...

I got it to work....thank you again.

I'm sorry, but I don't understand how to execute the code you suggested. To clarify, I would like a crosstab query with the following columns: Prior to Jan 2013, Jan, Feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec Thank you.

Thank you, I'll give this a try.

I am creating a crosstab query in VBA to report on claims on a paid and incurred basis. I would like the query to have 13 columns - one for each month of the current year and one for all claims paid prior to January of the current year. Is there a way to lump all data with a date less than Jan...

Hi All - I am not new to Access, but I am relatively new to Access 2010 and I've recently begun building databases after a six-year hiatus. I am in need of a good refresher of the program. --Lisa

what would cause leftover files? the back-end is not set to compact on close...hmmmm

Hi...I have an odd question. I designed a simple database for my sister to use at her place of work. There is a back-end database with two tables that resides on a server and the front-ends are stored locally on each desktop. There was a copy of the front-end left on the server and it seems...

I got this figured out...didn't realize that I had used a command that was not available in earlier versions of Access. docmd.closedatabase all is well now

I have made a fe/be database in Access 2007 for use in Access 2003 Prior to beginning the design I saved both ends in as *.mdb for Access 2000-2003 After completion, I saved the FE as *.mde - however, upon distribution the end-user is unable to open the FE with an error that it was created in...