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...

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...

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 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

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 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...

I have a FE/BE database and want to add a record to a linked table My code refers to the BE by name via a constant dim db as dao.database dm rst as dao.recordset Set db = DBEngine.Workspaces(0).OpenDatabase(cnstBackEnd) Set rst = db.OpenRecordset("tblReps", DB_OPEN_TABLE)...

As a favor for my sister I just created a database gratis for her use at work . There will be several users. Can I include "Terms of Use" that state that the database is my property and that it cannot be redistributed. I am concerned because her company has a number of branches that could...

Hi..I am using Access 2007 and am creating a membership directory. I have created the following tables: tblFamily: includes address, phone, e-mail - primary key is fldFamID tblDependents: includes family member's first name, last name, DOB, relationship (husband, wife, child) - primary key is...

I have recently upgraded to Access 2007 on Windows XP and switched from a PC to a laptop at the same time. The database that I built in Access 2000 on Windows 2000 pro is running well on the new system, however it is still a work-in-progress and the code is not fully tested. As a result, there...

Is there a way to assign the value of a public variable to a report textbox? I have a query that is created via a VBA SQL statement and the "WHERE" statement is stored in a public variable. I would like to print the "WHERE" on the report. I have tried: Private Sub Report_Open(Cancel As...

I am looking for an easier and possible less hardcoded method to accomplish this... I have several tables of considerable size consisting of Y/N fields - what I would like to do is create a list of the fields that are YES and list only the field names...for example Table tblWW_Funding has 7...

I have a large database (many tables) and all are joined to one main table with a 1-1 relationship. When trying to join a table I received an error msg that there are too many indexes on the main table and to delete some. Of course I can't do that...any suggestions?

I have a database that has been working properly for months...however, suddenly I am unable to add records to a number of my tables. Each of 10 tables are related to a main table with a 1 to 1 relationship - the relationships have not changed. Can anyone think of any table setting which I may...

I have a form that is intended to be used for both data entry and to edit/delete records. The form properties are set to: AllowFilters = YES AllowEdits = YES AllowAdditions = YES AllowDeletions = NO DataEntry = YES When a user opens the form from a menu they are given the choice for NEW, EDIT...

I have a form (frmInfo) that I would like to use for 3 purposes. 1 - to enter to information (data entry mode) 2 - to view existinging information (for a single record) 3 - to edit existing information (for a single record) There is a Main Menu that allows the user to choose, Enter New, View...