Platform: Windows XP - government network
The government recently went through a migration of all networked directories to a central repository -- that was in June. I recently discovered that one of my database users, who happened to be working from home that past month, was not migrated properly.
Problem. The home user was still entering projects into the non-migrated location, while the users at the office, are entering data into the new location. Therefore major information is not showing up.
Need to urgently pull the project data into the current database.
But, I cannot simply import this data because it will wipe out the data I've entered into this table.
Any ideas would be greatly appreciated. Thanks in advance. Barb
Yesterday my database crashed. It is the 'DEV' version for my application - so all of the current fixes/changes are in there and I have forgotten to backup!
It crashes when ever I try to enter the VBA editor, or build code. This occurred after a minor problem running some code (I forget which code).
The same occurs when I try to get into the code builder in the repaired version access generates...I have also tried using compact & repair to get in - but still no joy.
Can anyone offer any advice workaround to get this up and running again?
I'm trying to write a database for work (accounting firm).
I would like to start out with about 5 tables.
1) Client Information: Would include name, phone, etc and a field that stated what kind of client (F/S or Tax).
2) F/S Tracking: Would include name and date in, date started,etc.
3) Tax Tracking: Would include name and date in, completed, submitted to gov.
4) Employees: the names of the firms employees.
5) Job Jar: Would include employee name, and which client(s) they should work on.
What I need help with is the data entry form for the Client information. I would like to have it so I only enter the Client Name once, and only once, and not only will it update the client name field in the Client Information table, but the corresponding field in the F/S Tracking table (if the client type in the Client information table = "F/S") and the Tax Tracking table (if the client type in the Client information table = "tax").
I have tried to use an update query that runs when the Client information form is closed but I think I might be doing it wrong, because I always get the message that 0 (ZERO) records will be updated.
This is my problem!! I have created a Macro, using sendobject to send an email once the database has been opened. The email is to contain a copy of a report which i have specified in the macro.
On opening the database, a box appears with "Microsoft Office Outlook" on the top. The box says:
" A program is trying to automatically send email on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose no."
Then there are three buttons with yes, no or cancel on the bottom.
First question is why is this appearing and is there a way around it, and secondly, when i click on yes, i dont recieve an email and no buttons appear on my switchboard!!!
I use MS Access a lot for my work but a few days ago when I opened Access it asked for a username and password. I didn't set anyway passwords so tried to log on using the username: admin and a blank password which didn't work. I have tried every username and password combination that I could have used but nothing seems to work.
Is there anyway for sorting this out so that I can use Access again?
In basic terms, the contract table has basic contract info, resources can be assigned to a contract (via the Assign table) and we feed in exchange rate info also from another table.
Everything is so slow as soon as I put the BE on a share drive. I have done everything I can think of, I have changed to tlookups, I have changed the Auto options as recommended, analyse shows no issues, compacted the DB. It is unusable!
I notice on one form that it takes 1 second to calculate a field. The field basically uses a tSum to find the total cost of a contract (looks up assign to sum up all the attached resources). This seems to slow it down, but it does not explain the huge time it takes to load up.
I am considering that the issue may be down to the share where it is being located has too high latency (it is in another country, and it feels slow browsing through it)
Any other general ideas, or do you need more info?
I have a problem with duplicate records in my query. I know why the duplicate records are occuring and I have spent a ridiculous amount of time trying to fix the problem, but I'm really at a lost and am quite desperate for some help.
Here's some background info that shows the cause of the problem: I have two tables. In the first table (tblMainData), there are three columns of interest (P1, P2, & P3). The second table (tblGroupList) has two columns (PN & GroupList). A relationship exists such that the data in "PN" is parital-text values of the data in columns "P1", "P2" and "P3".
For example, "P1" in tblMainData may contain "A1235XX". The "A1235" is what's important, so that's one of the values that I have in "PN".
Continuing, I have a user form that uses the "GroupList" field as the RowSource for one of my combo boxes (cboGroup), and this field contains an (ALL) option. So, when a value is selected from cboGroup, I use the following Criteria filter Like [PN] & "*" in my query (qryFilterGroup) to look for those partial text fields that match what's in fields P1, P2 and P3. The results are then shown in a subform.
Here-in, I believe, lies the source of the duplicate records. In my userform, if "(ALL)" is selected under the cboGroup combo box, a new record is created for each field P1, P2 and P3 in tblMainData that contains data and that is related to the partial text matching Criteria. A new field is created because each field corresponds to one of the values in the "GroupList" field.
This is really difficult to explain, and I don't really know if I should continue without writing a book. If someone or someone(s) could be so kind, please have a quick look at my attached database as it's obvious to see my problem. Any help is greatly appreciated!!
I recently found a need to pass a message on to everyone that opened a certain access database. So in I thought the easiest way of doing this would be to use the startup page & macro on the Northwinds Sample Database that comes with access.
However, I kept getting an error because the ok button was pointing the main switchboard which doesnt exist on my database, so I tried deleting the following to see if it would sort the problem: -
' Closes Startup form. ' Used in OnClick property of OK command button on Startup form. DoCmd.Close DoCmd.OpenForm ("Main Switchboard")
Now I think I've made things a whole lot worse. When I opne the database I get that first startup form and of course the button doesnt work and everything else is disabled.
I could really do with some help on this one.
Thanks,
Marc.
P.s. Cracking forum guys, if it weren't for places like this people like me would be in a whole world of ****!!
I am so interested to see a solution to this little problem…i think ithis is one of my more complicated questions!!!!
Problem:
Where I work we have a series of machines… named “ C1, H7, H8 etc”
Each line has 3 counters on it,
Impressions – records the number of cartons used on the line Standard Pack – records the number of filled cartons with product Output – records the number of cartons that complete the whole line process and are ready to be shipped to the customer.
Sounds straight forward enough….but the process gets a little more complicated.
Some lines are referred to as joint lines… this indicates that the product from each line the output figure is joined together and totalled. So it is not possible to calculate how many each line completed for the output figure. Note… it is only the Output figure that is joint, each line still has it’s own impressions and standard park counters
Grouped lines are given a group code – P8 in this case.
The output counter is brought in to the database automatically via a linked spreadsheet and a macro, this data is then stored in a table called “DaycodeMachineShiftImpressions” you will see in this table that the grouping is referred to as Machine.
As previously stated we have no real way of working out the amount each line has output individually.. the way it is calculated at the moment, is to take the figure for P8 and split it into 2 equal figures and assign that to each line.
So in this case the figure assigned to each line would be 800, although you will see that this is not possible for H8 line as it only put 400 cartons on the line in the first place.
I now want to implement the following calculation to my DB,
(see Attached Spreadsheet)
the calculations a re stored in cells b12 & b13 in the spreadsheet.
so that the output figure is separated
in proportion to impressions made.
I then need the figure per line to be fed back to the “tblProduction” output field..
in the tblproduction the data for P8 is stored to line level so in this case as H7 and H8, hence why i want to use the calculation to work out the output figure per line...
Can this be done automatically, if so please help me…
I am so interested to see a solution to this little problem…i think ithis is one of my more complicated questions!!!!
Problem:
Where I work we have a series of machines… named “ C1, H7, H8 etc”
Each line has 3 counters on it,
Impressions – records the number of cartons used on the line Standard Pack – records the number of filled cartons with product Output – records the number of cartons that complete the whole line process and are ready to be shipped to the customer.
Sounds straight forward enough….but the process gets a little more complicated.
Some lines are referred to as joint lines… this indicates that the product from each line the output figure is joined together and totalled. So it is not possible to calculate how many each line completed for the output figure. Note… it is only the Output figure that is joint, each line still has it’s own impressions and standard park counters
Grouped lines are given a group code – P8 in this case.
The output counter is brought in to the database automatically via a linked spreadsheet and a macro, this data is then stored in a table called “DaycodeMachineShiftImpressions” you will see in this table that the grouping is referred to as Machine.
As previously stated we have no real way of working out the amount each line has output individually.. the way it is calculated at the moment, is to take the figure for P8 and split it into 2 equal figures and assign that to each line.
So in this case the figure assigned to each line would be 800, although you will see that this is not possible for H8 line as it only put 400 cartons on the line in the first place.
I now want to implement the following calculation to my DB,
(see Attached Spreadsheet)
the calculations a re stored in cells b12 & b13 in the spreadsheet.
so that the output figure is separated
in proportion to impressions made.
I then need the figure per line to be fed back to the “tblProduction” output field..
in the tblproduction the data for P8 is stored to line level so in this case as H7 and H8, hence why i want to use the calculation to work out the output figure per line...
Can this be done automatically, if so please help me…
I need to know the best way to insert data into the backend without cause major bloating of the backend. I am currently inserting about 20k records at a time using an INSERT INTO statement. The backend went from 83mb to 511mb trying to insert the last 20k records.
I am absolutely puzzeled with a problem we are having with an Ms Access 2000 application, which is the front end to a SQL Server database. We have a database which was working fine for over 6 months. And now all of sudden users are intermittently getting the error messages:
"Error Executing this command" AND "You cancelled the previous operation."
I removed the error handling code from the application to get more detailed error messages and we got the following error message:
The expression On Click you entered as the event property setting produced the following error: .
The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
There may have been an error evaluating the function, event, or macro.
This is only intermittent and when they close the database and open it again it works fine for a little while and then the error occurs again. As you can imagine this is a major inconvenience for users.
I have searched the web and forums and there just seems to be 101 reasons why this could happen. Nothing has changed on our system which might cause this occur so I don't know why this is happening.
Could anybody provide any ideas on how I might go about trouble shooting it. We are thinking of opening a support call with Microsoft but the error messages are so generic that I'm not sure what help they could be.
Any help / ideas or suggestions would be greatly appreciated.
Looking for the user to select a product name from a drop down box (not type in) when running query / report which will return details on only that product rather than all others in the query.
I have got major problems with the custom dialog boxes -- have got a table of product names, a query called current stock ( active products) . I can easily get a standard dialog box by putting [product code] in brackets in the query and this is not a problem. However in getting a custom dialog box I have had lots of problems.
Created a form called form999 which has product name field as a combo box and this has been named master1 . Clicking the form on it's own brings up the dialog box correctly and the drop down box selects the current products which is should do. However linking it to the query I have put [Forms]![form999]![master1] in the query and it will not link unfortunately and is driving me mad. Upon running the query it simply brings up the standard dialog box with [Forms]![form999]![master1] as the "enter parameter value. Understand code is required to get the OK and cancel macros working etc but when I click the query it should bring up the custom box which is the first stage and it is not ?? Any assistance would be greatly received.
Are there any sample DBs which have a field or related parameter as a customer dialog box -- have looked for examples without success.
