Search results

Currently the input table is populated/updated over a course of 2-3 weeks as information is made available, either manually or via Fillable PDF form imports (still working on this piece). Once all info is available and a contract is signed, the Facility is created in the database and then my...

It is 1 table with 100 columns with an auto number field to create the "Facility ID" primary key. My data entry form is bound to that table, which is launched with "Add Record", to input all the info, i.e. Facility Name, Facility POCs, Phone Numbers, Emails, Programs, etc. After all the info...

I have a split SQL/Access database and an entry from with around 100 fields on it that gets split into 8 other tables. I currently have it setup as a 1 pass through query with multiple INSERT and UPDATE clauses, which works just fine. I'm just wondering if it would operate any faster, or...

Don't know what happened but its working now. Tried compact and repair several times with no luck. Made a copy of the database, no luck Not wanting to have to start from scratch as there are about 100 lines of code on that form, I made a copy of the form to start digging into it line by line...

Today when I open a new database that I've been working on for about week, its acting weird. When I open it, it launches the main page, but when click a button to open a new form, nothing on that forms works unless I open and close the VB editor. After that, everything on the form works...

So are you saying because it's a PK in the original Notes table it can't be appended as a "Number" in the history notes table? It's not set as a PK in the NotesHistory table, and if it is, I apologise as I must have uploaded the wrong copy. Also each Note ID is already a unique value due to it...

Wondering if someone can take a look at the attached DB and point out what I am missing as I have been messing with this for over 2 hours and keep chasing my tail. Whenever I am running the EquipmentHistoryPt2 query, I am getting the Attached error message. When I look at the tables, I can't...

From what I could tell, I would have to build a query to assign the PK for every one of my tables in order to use that one. Could be wrong, as it was just a quick look so I figured I would check out isladogs example as well

Thanks, i'm going to try to work on this next week, for some reason, I can't seem to understand how to set this up for some reason, which is driving me nuts because I can usually look at something and eventually figure it out

Any chance you could upload that zip file on here as it requires me to create an account and login in order to download it? please advise thank you

Finally getting around to digging into this more, I noticed that its listing all the fields in alphabetical order, is there anyway to make it list them in the layout order, i.e. 1st field on form is 1st field listed, 2nd field is 2nd listed, etc.?

some of the queries are pass-through queries Guess I could just leave the DSN alone on the queries as the tables are the same in both DBs....

Thanks to all, i'll check the link later. It is definitely a bit of a pain have to remove/readd every time, however I did find help with the tables, just not the queries Click on External Data > Linked Table Manager Check the box at the bottom for "Always prompt for new location" Select all...

Currently I have 2 matching databases, 1 for Production and 1 for Testing, that are setup with different DSN files for linked tables and queries. Is there a way to easily change the DSN setup on the access side instead of removing all the linked tables/queries to the Testing DB and re-linking...

Thanks to all for your input, think I figured it via scripts on SQL server. So far everything looks good and appears to be working as intended, so I will have to have a few users get on the my test front end and verify it works on Monday.

I thought about that too, but that wouldn't help me in the sense of only bringing over the tables I need, vs all tables, to the new DB.

I am completely fine with redesigning the whole thing, which is I why I made this post. I am just unsure of the best way to copy a tables from 1 DB to another DB withing the same SQL server and maintain all the relationships, indexes and default values.

CJ, I started going through each form and identifying the unneeded code, queries and tables but half way through decided that it may not be a bad idea to redesign the front end all together, which is why I was leaning towards making a new database and making a new FE starting from scratch and...

June7, It will be from the existing DB to a new DB on the same SQL Server. So far i've discovered that Tasks > Exports only moves the tables and data, no Schema Unless I didn't do it correctly, the Tasks > Generate Scripts looks like it will give me what I was looking for, but it only let me...

I currently have a FE/BE database, that was created by a former coworker, that has been modified over time and the maintenance was not maintained in the best manner. When new "Features" were added, new tables were created in the BE, new Forms, Queries and Reports were created in the FE, but...