I have a process that takes a few minutes to finish. I would like a message box to appear and stay up for the entire process. I have a message box that tells the user it may take a few minutes to complete and one that tells them when its complete.
View RepliesI attempted to add new queries, reports, and a form to a shared database. It bombed out and I found that a user was changing data in the tables at the same time.
Now I cannot access the database at all (front or backend) and receive the error message: “The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time”. (I have verified that no users are currently logged in.)
Access to the data is critical to my department and I’m scrambling to fix this. Can anyone assist me?
Thanks!
I'm not sure if I am biting off more than I can chew. I have a text field in each record in my database (Inherited) The db has nearly 5,000 records. I would like to split the field into records in a seperate table. An Example of the table as is now;
Code:
MemberIDBoats
5882Opossum(78-80) (87-89) Otter(80-84) Opportune(91-93) Turbulent(97-00).
5883Astute Auriga Aeneas Affray Amphion
2407H34 O10 Porpoise Trenchant Tapir.
I want to create a table as follows;
Code:
MemberIDBoatFromTo
5882Oppossum19781980
5882Oppossum19871989
5882Otter 19801984
5882Opportune19911993
5882Turbulent19972000
5883Astute
5883Auriga
5883Aeneas
5883Affray
5883Amphion
Etc.
Is this possible in one hit or do I need to process the records without dates first and then run another process to split those with Dates? I say dates but the field is a text field. About 15-20% of the records contain dates which are always enclosed in parenthesis.
Hi everyone
Is there a way of setting a forms propertie's so that the form always stays 'on top' and visible, even if it isnt the focus. The only example i can think of to explain what i mean it the msn messanger window that you can choose to 'stay on top' even if you click on a window behind it?
Any suggestions much appreciated.
James
I have a Main Form that utilizes tabs to control several other forms by opening, closing and making them visible/invisible. One of the forms needs to be closed when its tab on the Main form is unselected. The problem is that once the form is closed, when it opens up again it opens right infront of my Main form's tab control so I need to move it down an inch to get to the tab control.
I've positioned this form where I want it and saved it numerous times. But once I select the tab, it opens up right ontop of the Main form's tab control again. I have the AutoResize set to No and the Auto Center also set to No.
Any ideas how I can get this form to stay put?
Any help is most appreciated. Thanks.
In the zip code field of my form, if the first number of the zip code is a zero, such as 02436, the zero is deleted as soon as I leave that field. The zero won't stay and I want it to so I will have a valid 5 digit zip code. In other words, as soon as I leave the field the zipcode is changed to read 2436 - without the zero. How do I fix that? Thanks.
View 2 Replies View RelatedI have a problem with validation attached to a field or an entire record (displayed via a form) in that, if the user exits that field/record by moving to the next Access record, when the message comes up, it is this next record that is displayed, not the invalid one. This is confusing.
My users usually use a filter when updating (sorry about the alliteration!) & this mostly displays just the one record out of thousands. When they remove or change the filter, the message is, as above, displayed over the wrong record.
Ideally, I prefer the entire, quite complex record to be validated at one 'go' as many of the fields are interlinked.
I have achieved this, sort of, with a button called Validate which the users are supposed to click when they have completed adding or updating a record. Most of the validation code is attached to this & it does keep them on the right record. However I can't make them click it.
I have tried controlling the record displayed by making the record pointer go back one or forward one when an error is found but this causes problems with the first/last record in the table or filtered results.
Each record has an unique number. I have tried storing this number & coding a filter to re-display it when an error is found but this is confusing when the users were not filtering to only one record. Also it only works once. If further errors are found, the application gives up.
Hi everyone,
I have created a combo box in my form, the options for the combo box are coming from a table. It all works fine expect for some odd reason, when I click on an option in the combo box then come out of access, when I go back into the database the one I had chosen has gone. Do you know how I do so what I put in the combo box will stay?
Thank you in advance for your help.
I have a form with 6 option groups, each with 2 option boxes (-1 & 0). They are triple-states and start off in null mode with a validation rule of "Not Null". The idea is to ensure the user has decided something for each option group before being allowed to save the record.
The problem is that each time I load the form, the first box I select, all the others then default to the same option (no longer null).
Any Ideas?
Thanks,
Ben
When I try to edit fields in a subform the cursor always jumps to the first record's first field with a tab stop. I can not complete the modification and the cursor jumps back to the first record. When on the first record and on any other field the cursor will jump to the first field with tab stop.
I use Access 2003.
My form has a button that has a calculated field on it (a dcount(...)). When the button is clicked, a couple of conditions are checked and if all is ok, it runs the vba code. If the tests fail, it returns to the form without running the code. All works correctly, except that the dcount number has disappeared. I finally figured out that it is now hidden behind the button. How do I bring it forward again programmatically?
View 11 Replies View RelatedI have a database For customers of the company, when you open the main form through the search form , there are a filter . when you try to move between orders of this customer, there are a mssage (Asking you to approve of movement between the customer orders). to this point no problem, when you approval to move , cancel the filter on the main form with a stay at the current record (current customer).
View 14 Replies View Relatedis it possible to have a form page stay open for a time limit and then automatically close and open another form?
Reason I ask when a user clicks to open the database I want a splashscreen stating terms of use etc to stay open for a few seconds before it opens into the main database.
I have two forms ( main and Sub) . Every time I want to enter a new record the main data goes blank (not required) and the sub data goes blank for new data ( required). The new subdata is related to the main data. This way I have to retype all the same data in the main form which I wish not. Need making the main form data stays so I only type the subform.
View 1 Replies View RelatedI have about 125 .mdb's I want to go through, and in each one, select a table and run a "find duplicates" query, creating a table of duplicate record info for research into why there are duplicates.. I am aware I can manually do this within each .mdb, but would be happy to be able to automate the process.
I wasn't sure what to search for, which is the reason for my posting. If anyone has an idea (and not questions on why I want to do this, or probs. I might encounter), I would be most appreciative.
Thanks!
I developed a sales database that contains around twenty forms, (in addition to tables, queries, reports and 2 modules). In these forms, I'm setting recordsets, select statements and filters. We recently hired a person to set up a Virtual Private Network. After spending a couple of thousands on a server and countless hours reprogramming the database to have multiple users access the database out in the field, (via Verizon broadband network card), we were unsuccessful to use the database since it was taking too long to download the data or perform any calculations. The database is split. The users have a front end.
The person setting the VPN has suggested that I get rid of all the queries that I have in the forms (which is impossible), or use Visual Basic for the front end instead of Access with VBA.
When I set up the recordsets I use the following setting:
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
I don't know what to do. This program is very complicated and I don't want to have to reprogram the whole thing with Visual Basic, and I don't know how the front end is going to work if I eliminate all the queries, select statements and filtering.
Any ideas, comments or suggestions would be appreciated.
Maritza
Hi all,
I need a button on a form to not only add a new record but also run a query. I can't see how to do this using a macro and my coding experience is limited. How can I get this button to do both of these actions?
I think that I should add that the add record action must happed first. However, I have noticed that this automatically increments the record number in the navigation section to the next number and blanks the firelds in the form (which is data entry mode). As the query relies on information given in the fields on the form, i don't want the field to be blanked. I'd like the the for to stay on the same record until the query has finished. Once this has happened, I'd like the form to reset itself so that it looks as if it's just been opened and the first record is the new record (just as if you'd opened a form in data entry mode).
Sorry, complex I know. :( :confused: I'm sure there's some one out there how's got the answer though. :cool:
Cheers,
Matt
In my database i need two process in the database one is SOD(Start of Day) and the 2nd one is EOD (End Of Day). The purpose of these process to run multiple hidden queries in back-end. In both processes there are several queries to run. How i can built this but this is necessary for database. another thing these process execute only once a day. after login i want to run a form that will check that SOD is performed or not if not then SOD (Run SOD) Screen will appear if SOD not perform yet then system ask for SOD Process to run otherwise disable my dashboard items. and 2ndly if EOD not performed last day then system will run normally and not ask for SOD process.
View 4 Replies View RelatedDear All,
I prepared times ago a database that contains important data that will be frequently updated.
Since yesterday I cannot load the database anymore. I get a pop-up with following statement:
Quote
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time
Unquote
If I click ok, the loading process will be aborted.
I'm the only user of this database, neither the database nor the directory containing the database is sharable. It is located on the harddisk of my computer which nobody from outside can access.
What can I do to recover the access to my database?
I use MS Office 2003 but tried to open the database also on MS Office 2000 with the same result.
The Help function of MS-Access does not really help.
Who knows how to solve the probleem????
With regards
Siegfried
I have this update query that does not quite work. I have attached a picture of the design view. What I need to do is process each line and update the processed field (yes no) to minus one to then exclude that record. Unfortunately when this query runs, it sets the processed field after matching all records.
So how do I process line by line
I have 4 csv files, that need to be imported into Access.
1. I'm building 4 linked tables so users can update the table as needed. Then run queries based on these tables to produce report. But maybe there's a better way? the file name and location might be dymatic, so anything like 'getopenfilename' would be easier instead of linked tables?
2. These data need to be clean up first to become a 'database table'. (Delete first 2 rows, delete some columns, remove duplicates etc.) I know how to do them in VBA Excel, but never used Macro in Access before.
Hey, i'm working on creating a database.
it's involves a customer booking a ticket for a flight.
i have three tables, customer, booking and flight.
anyways, i'm having trouble applying the price the customer needs to pay
say there's an attribute on table Flight -> flightprice.
when a customer makes a booking, discounts are applied to the price.
discounts include:
1. Special seasonal discount, (eg from Sept to November) - 4%
2. Member discount - 6%
3. frequent flyer discount - 5%
4. other discount - 4%
the thing is that these discounts are stackable. ie, applied together.
(eg a person eligible for member discount and frequent flyer discount will get 11% discount total)
i know that if only one of the discount rates apply,
then i'd be able to create a new table called Discounts
and have a one to many relationship with the Booking table.
but i'm not sure how i need to bypass this when several discount rates can be applied at once to a single booking.
-------------------
also on another note.
how can i make the seasonal booking only be applied if the date of the booking lies in between the promotion season?
We have a user that wants to pull data from multiple oracle tables into one access table. She will probably want to run this process daily. The tables will join easy enough, but I wasn't sure what the best way to go about doing this was.
I haven't used access very much. Again, this is a member of the user community and she is wanting to do this thru access.
Ideally, if it could be automated some way, or set up in some way where the user would not have to do much more than start the process (and not have to redo any "select" statements each time). I would assume some kind of combination of links and import (maybe using a macro?), but again I know very little about access.
Any guidance will be appreciated!
I have a large database of items we sell on Amazon, I am looking to automate the process of uploading the inventory.
I am uploading a tab delimeted text file using the following code,
With CreateObject("msxml2.xmlhttp")
.Open "POST", strURL, False
.setRequestHeader "Host:", "mws.amazonservices.co.uk"
.setRequestHeader "User-Agent:", "VBA"
.setRequestHeader "Content-MD5:", md5hdr2
.setRequestHeader "Content-Type:", "text"
.send c2a
Forms!Form1.Text3.value = .responseText
End With
I am confident I have the signature and the MD5 Header, but I cannot get the data into Amazon!
I keep getting a non-descript error "InputDataError".
When debugging my Play API, I was told that the "send" command was not uploading the file contents, it was uploading the filename! So c2a is a string variable that contains the tab delimited data. This works like a charm for Play, but no joy for Amazon.
I am just getting started creation a new database for batch process production records that will be filled completed in the field real time. I had started out creating a table that had fields for each step of the process. Such as:
[Batch number]
[Equipment] (lookup)
[Process] (lookup)
[Step 1 start time]
[Step 1 comments]
[Step 2 Start time]
[Step 2 comments]
[Step 3 start time]
[Step 3 comments]
I have seperate tables for listing equipment, Processes and standard times for each step of the process. I realize that another way of doing it would be to create another table with a list of the process steps and then my table would look somethink like this.
[Batch number]
[Equipment] (Lookup)
[Process] (lookup)
[Step] (Lookup)
[Start time]
The problem is, I want a form (batchsheet) that already has all of the steps listed for the data entry person and simply a blank for them to enter what time they completed each step. I dont want the client to have to select a [step].
Hi All
My department has customer database using microsoft access with the main table being a linked table to SQL-Server database down in IT department.
I've only been recently made aware that the staffs have been having problem when trying to change or delete old data. It keeps on bringing up the error message
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
which is hardly the case since each staff are assigned only one customer to work on.
While it is technically possible to have many people working on the same data, business wise, it is impossible to do that.
I still come up with the same error even when the IT department confirms that no one accessing the SQL-Server table and I was the only one logged in.
This leads me to believe that there is something in the code that somehow preventing the table being edited or deleted. The problem is the database is so huge and was designed by my predecessor so I do not have any knowledge of the complete working of the codes behind it.
If it's the problem with the code, can anyone tell me what sort of codes caused this? If not, can anyone tell me what happened?
Any help would be most appreciated.
Thank you