Search results

I'm having this exact issue. My problem is that I did the updates and it didn't fix the issue. Still being locked out if 1 person is using the split database.

I ended up getting it all to work; however, that being said I think I'm going to redo the whole survey database. There is simply too much room for error the way it is set up. Thanks everyone for your help. That being said I could really use a course in VBA. Any recommendations? Free if possible.

The existing reports were ok. However they were based on two piece of criteria. Type and Date. There are tables and queries but only two tables out of the 12 had a relationship and there was no relationship to the main table that holds all the data. I did create relationships. The data doesn't...

I guess I don't know enough about code to understand what you are saying. I only kind of understand the code listed above. Where are they calling the query listed above. When I manually create a query I have to list criteria to not show nulls. I can manually make that into a report but can't...

I am working on a database that I didn't create. I was asked to create a report which I though wasn't a big deal. However the database is setup completely different then what I am used to and everything is written in code. What I have so far is the end user choses a Quarter date, either 1, 2, 3...

Sorry to all. Had the wrong table opened at the time.

No, a new data macro appears, not the old one.

I created two data macros in Access 2013. I created these Macros by having my table open and then I went to the ribbon and selected Table. I then used the AfterInsert. The first Macro was an AfterInsert Macro, and the second was an AfterUpdate Marco. I closed out of them and thought I could...

Thanks everyone! I am going to include the examples given here to my students. Although programming isn't until the end of the textbook, it does give us the ability to create views which is what we are covering right now.

I am adjunct currently teaching Intro to Databases. An example in the text books for creating new views in SQL in Access 2013 is as follows CREATE VIEW Games AS SELECT ItemNum, Description, OnHand, Price FROM ITEM WHERE Category='GME' When I run the query it gives me a syntax error in the...

Moving the files into archived tables worked great! I decided to leave messages on, so that they don't delete archived employees that never officially archived (In case of error). Thanks again for all your advice!

I was just going to have them go into one table called archive. I had already created a form that would put the information together so if they needed to see the archived data they could. Perhaps though it would be beneficial to have the information in the original archived tables. I do have 4...

I will give that a try Pat. So any type of one to many relationship needs to be exported separately then. Can I create a query for each one and then put both queries in the append query? Or will I still have the same issue?

I have a database with employees. The tables are as follows: Deptdatatble Depttble Emptble HRtble Servicetble Servicedatatble Archivetble Classestble Classdatatble At certain times, I want to archive employees out (lets say they are terminated). When I do this, something strange happens. If an...

They simply don't want to keep the database filled with people that no longer work for the company. Also, they do not want non-employees showing up in reports. I we add an extra field to show the record as archive, (which we do have), then all the queries will have to be edited to have do not...

It doesn't hold the sort. This is my SQL that I have tried to save, over and over again. SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName FROM Employees ORDER BY Employees.LastName; This is what it reverts back to SELECT Employees.EmployeeID, Employees.LastName...

I have a database with 14 tables. Periodically, (like once a year) we like to archive the data into an archive table (within the same database). This works well if the person we are archiving has data in the main related table. However, the issue I am running into is if we have an employee that...

That is because it is not holding the sort. I just pasted my last attempt in. I have tried putting Last Name first, but the query simply doesn't hold. Is this an issue perhaps when trying to change the query of an unbound field? This only happens when I try and change a query of an unbound...

This is my SQL that I have tried to save, over and over again. SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName FROM Employees ORDER BY Employees.LastName; This is what it reverts back to SELECT Employees.EmployeeID, Employees.LastName, Employees.FirstName FROM Employees

I have a an unbound field that allows me to search for an employee. I would like the drop down list to be alphbetized, however, it doesn't hold the sort. I have completed the following steps. 1. Right clicked on the unbound field 2. Selected property sheet 3. Selected row source (which brings...