Search results

(sigh... So i know i messed up lol) In a complete oversight on my part I have a form where the user can enter data to be added to the master data table that holds programmatic information and the value of each item. In the form I designed the user only fills in 5 fields out of an available...

I seem to always have these headache issues! A team im helping had an existing database that was created in all the wrong ways possible. It was not split, not indexed, UI was atrocious, and no real data controls or validation. The database was a basic inquiry type set up, someone calls the...

For years, I've used a setup where data is imported into an Access table, and users could use forms to query the data any way they liked. After they select from a series of drop down boxes, they can run a report and print out the pages and begin collecting data from the field. Members of the...

I am trying to convert a database that I created using Access 2007 to and Access 2010 Web Database (I have migrated to Access 2010). I have run the web compatibility check and have made corrections to all of my tables that were required. I then signed up for a trial of Access Web Services and...

In my effort to make a very simple database that compiles monthly data (linked from several Excel Spreadsheet) and exports the data back into Microsoft Excel, im stumped on 1 thing. My new plan requires the User to select from a combo box a list of the sites (or blank if All) and then a Date...

To be more specific Im working on a project where the users have used a MS Excel workbook to keep track of projects (Due Dates, Status, Project name and # etc). They now have thousands of records and find themselves overwhelmed. I've managed to import all the data into Access tables and create...

I've designed a database that three people use. Each person has an identical split database on their PC's. However each person is in a different state. I'm trying to figure out a way in which they can send me a copy of their data table, I append the work they did, and then send them the fully...

I’ve searched the web and this site and have found out it’s possible to connect a MS Access front end to a mysql back end. I am interested in taking my current database which is already split and change it to an access FE/ mysql BE. Since I already have a split database, I downloaded a program...

I created a very simple code that checks the current date, and if the the current date is greater or less than the pre programmes date open a msg box. Private Sub Command1_Click() If Date < 1 / 20 / 2010 Then Dim ButtonClicked ButtonClicked = MsgBox("Sorry, your current license has...

I was thinking of ways to ensure back up of data, and I wondered if there is away to write data to more than one table at the same time. If not what is the best way to accomplsih something like this? Basically if the network crashed could data written to a local table be used as a potential...

I currently create programs in Visual Basic and MS Access. Things are going well but demand is also growing fast. Managing many software packages is becoming more and more time consuming. I am interested in finding out what I need to create the following. 1. A Web based database 2. Clients would...

I am trying have a calculated field which gives me the year to date amount of orders. I currently have a query which is set up to return the amount of orders Between user defined dates Example Between [forms]![fmr1]![txtbegdate] AND [forms]![fmr1]![txtenddate] Now this has worked fine but...

I was trying more testing with the packaging toold that comes with the developers extension. I packaged my database and everything worked well on the computer without Access 2007. However, when I made changes to the FE and wanted to update the deployed version. I could not overwrite, delete...

I have been working with a client who is looking to expand on the original capabilities of the database. Basically he would like to be able to access his data remotely. Background: Database is designed to track donors who contribute to various charitable funds. The one table is loaded with...

I've done this tons of times but for some reason I cant figure out whats wrong. I have a query where criteria is passed through a form (frmContactFinder). After writing the query I tested by using "Run", I was prompted to enter First Name, then MI, and then Last Name. I entered a valid name and...

I have a packaged database that runs smoothly on the network. However I would like to be able to have the option to export certain queries to excel for "one time" analysis from time to time. The computers this program is installed on do not have MS Access and thus are running Runtime. How can I...

Currently my brain is fried and I can't think of a way to qrite a query that is based on multiple fields. Example: 5 Fields: Donor,2002D,2004D,2006D, 2008D - Donor is the names, other fields show if they donated that year (Y or N) Question How do I query to bring back records that show...

Developed with Access 2007, all computers running Vista Question #1 I know I've seen this question on this board but I cannot find it. I have a properly split database. The back end is located in a shared public folder, which is mapped to each computer. They are all connect via 10/100...

Just thinking about experimenting. Has anyone shared a properly split MS Access database over a NAS device?

Just wanted any recommendations on good books for teaching VB .NET. I have solely used MS Access for the last 7 years but prior to that I developed in VB 6. Just wanted to know a good book that is detailed and can get me up tp speed.