Hi all. Can't seem to find a similar thread although I'm sure there must be one.
I have a macro that runs update queries when exiting the database. What I'd like to do is display a message whilst the updates are running. However, I only seem to halt the macro until the user clicks the ok button on the message box.
Any ideas?
Cheers
I have a form that sets criteria in a series of make-table queries that go on to power a report. I've set up a macro to first open the form and then run the make-table queries and then open the final report. My trouble is that before I can set the criteria in the form I'm getting prompted by the make-table queries.
How can I stop the macro so I can input data and then re-start it? I tried using a stop macro command but that didn't work out for me.
Thanks
I am basically setting up a macro that will change the value for a field from "N" to "Y" for all records from a query. The macro works fine except for it does not know when to stop and gives an error message of "You can't assign a value to this object" after it has gone through all of the records and there are none left to change. The macro is set up like this:
OpenForm Action : This form is populated by the query and I set the Where condition to open records that don't already have a value of "Y".
SetValue Action : I use this to set the value of the field to "Y"
Close Action : I use this to close the form and save the changes
RunMacro Action : This is where the problem is. I use this to repeat the macro so it can go through the rest of the records that still have the field set to "N". I need to set the Condition or Repeat Expression so that it checks if all of the records have been changed. It either needs to check that all records have the field = "Y" or check that the macro is on the last record. Basically something that will cause the macro to not open itself again when there are no more records to be changed.
I have a macro that opens up a form called SLA Complete Form - The macro then goes and examines two fields on the form to see if they contain data and if they do not then it displays a popup box with a message.
The form that gets opened up can have anywhere from one record to approximately a hundred records.
How can I get the macro to stop running when it hits the last record on the form without displaying an error message. I am currently using the next record feature in the macro.
I completed the Op[en form and find specific data wizard and it works.
Here is my issue: If there is no data to find, I get a "Stop Macro" error.
How to change this?
I have an Access 2010 db on a shared network drive. All users accessing the db are running Windows 7 OS and have a licensed corporate version of Access 2010. The advanced options "Shared", "Edited record" and "Open dabases by using record-level locking" are turned on. Additionally, the locking time limits are set to their default levels. If a user selects the save icon after making additions or updates, the following waring message appears:
Costar Job Database can't save design changes or save to a new database object because another user has the file open. To save you design changes or to save to a new object, you must have exclusive access to the file.Since I developed the db, I am the only one that makes design or object changes. I know that users don't need to select the save icon to update the db, but I don't want them to "freak out" if they select save and see the message.
Is there any way to prevent the message from being displayed?
I can manually stop the AutoExec macro from running by holding down the shift button - how do you do it by VBA? I'm opening the db from Excel, and I don't want the Switchboard to display ...
View 1 Replies View RelatedI have some code (see below) that checks if the start date text box is blank or greater than the end date, and if so, generates a message box and sets the focus back to the start date textbox. There are command buttons on the form that open queries based on the date fields. This all works fine.
However, if the user changes his mind and closes the form without filling in the date field, the message box "Please enter a start date" pops up repeatedly. How do I specify that a text box is required UNLESS the user is closing the form?
Code:
Private Sub txt_startdate_LostFocus()
If ((IsNull(txt_startdate) Or (txt_startdate) = " ")) Then
MsgBox "Please enter a start date.", vbOKOnly
[Code].....
I have a simple code for an access form button to send a email message.
It looks like this:
Quote:
DoCmd.SendObject , , , [emailaddress], , , [CustomerId], "Dear " & [CustomerName] & "We inform you that (...)"
When I click the button an email message window pops up, and if I do SEND it, everything ends well.
The problem:
If choose NOT to send it, and I close the email message window, an error pops up causing my database to close (I use access runtime).
Do you think I can add anything to my vba so this error doesnt occur?
Is there anyway to customize the background of a message box that is brought up via a macro or VBA event? It would be kind of fun to have a stop sign image in the background of a "save and close form" prompt.
View 6 Replies View RelatedIt is my understanding that a custom macro was built to pull text data from a file and import it into Access in the appropriate fields. This macro no longer works and will return the following error message:
"License information for this component not found. You do not have an appropriate license to use this functionality in design mode."
It only gives an option to click OK. When you do it shows a box called "Action Failed" that lists the macro name, condition, action name, and arguments with three button to click on the right of the box: "Step" "Halt" and "Continue". It appears that only the "Halt" button is available to be clicked.
Does this sound like an issue with the Access license or whatever license the macro might have? We're trying to decide if it's possible to restore the functionality of the macro.
I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro.
Here is the code i am using at the moment, all I want to do currently is click the first button, then get the second macro to execute. But no luck, getting error 2157 "cannot find the procedure"
Code:
Private Sub Command3_Click()
MsgBox "1st macro running", vbExclamation, "Note"
Application.Run "teststart1"
' Application.OnTime TimeValue("19:55:00"), "teststart1"
[code]....
Hi, im struggling with my project. I'm not sure how to pursue this, but when i a customer to book a lesson, i want the booking to be not booked twice.
So i have to prevent the date of when the customer wants his/her lesson to be booked on the same day as the other person.
I'll be very very grateful if anyone can help me with this.
Thank You!
i have created a new utility DB that has only one form..when it opens I set the startup form "Main" and on the OnOpen event of this form I have some code to open another database and close this one...
this means that whenever i open this database, it opens, opens up the other one and this utility DB closes...and i cannot access it coz it always opens and closes automatically...how can I stop it from executing to be able to edit its VB code?!
Thanks, this is driving me mad !
Not too long ago, I wrote a top ten ways to make sure your question was never answered. I'm going to append it.1) "Help Plz!!!!!!!!!!!!!!!" does not an answer give.2) http://www.access-programmers.co.uk/forums/showthread.php?t=850423) "I'm totally new to VBA" is not an excuse when you're asking for VBA. Someone providing you with the code teaches you nothing. Show code, show where you're stuck, show something. 4) Stop telling us how new you are and do not do suck up ("You guys are so great, and I've learned so much blah blah blah"). We know why we answer. If someone helped you before, reference that, and that's it. 5) The subject is just that. The freakin' subject. Remember that. "I'm stuck" is a bad subject. "Help with error resolution" is better.6) We do this for free. Remember that.7) Cross-posting -- not such a good idea.8) Never, ever ask that posts are sent to email addresses. Are you that lazy?9) Explain, in detail, what the issue is. The posts that are like, "I have this table where I query it, and it doesn't work!" followed by the query have no clear purpose. Make sure you know what you are asking for.10) For god's sake, try to figure it out on your own. None of the stellar answer people (myself, boblarson, docman, rural guy, and the others I'm forgetting) got this way off of message boards alone. Yes, questions were asked (most likely before this place existed), but for the most part, programming is a self-tutorial through trial and error.
View 13 Replies View RelatedI have an update query that looks for a name eg "first"
then it is suppost to update a field with 1
I have a command button that runs the query
This then says "you are about to update 1 row(s) so i press yes, but the field doesn't update
But if i flick through the database and then come back to the record it has updated
How can i do this so i dont have to flick
Thanks
Andrew
This should be a simple one.... But can't seem to find the answer.... I have put a line of code on the open event of a seconadry form.... First form is "Clients" second form is "Contracts" If no the client has no contracts the code goes.....
Private Sub Form_Open(Cancel As Integer)
If IsNull(DateOfSale) Or DateOfSale = " " Then
MsgBox "No Contract Exist"
Cancel = True
End If
End Sub
After the first message box I get a "Access" message box... "The OpenForm action was canceled" ....... Thats fine.... we know that... But we don't need to know that. How can I stop the second message box from opening? Or can I ?
Hi,
On our database, we have a form that has 2 calendars. A start date and an End Date. The users fill in the name, and a couple other fields. Then select the start date, and end dates.
When they hit submit, the form enters into the table this info for each date in-between the start and end dates. For example if the users enters they will be taking vacation, then they enter 8/1 as a start and 8/10 as a end date. It will make an entry for each day. This works pretty well for us.
But I would like to improve it if possible.
Let say, a user a month ago made an entry that they would be work 8/23 at home. So in the database it has 8/23 at home.
Well, this week they decide they are going to take a vacation 8/21-8/25. So they make the new entry with start date 8/21 and end date 8/25. The form enters all the info just fine.
But if someone runs a report they see 8/23 at home, and also 8/21, 8/22, 8/23 ect on vacation. So gets a little confusing to where they actually are
So I was wondering if there is a way, for the database to prompt the person making the entry, that there is already an entry for 8/23 and ask if they want to delete it or save it? Then continue on creating the entries for the rest (8/24 and 8/25 in this example?).
Has anyone seen something like this? I was going to search, but not really sure what to search for on the forum.
Thanks
Hi,
How can I stop user from closing the form if the mantory fields are not filled up? I try using gotocontrol but it is not working.
Hi
I am fairly new to this and have set up tables to include specific details. I need to type in a name works number etc on a person already entered. So how do I once details have been entered stop having to put them in again. I have created a form for data entry
Please explain simply
Thanks :eek:
I have two table. Deliveries Created (DC) and Goods Receipt (GR).
I have a query which links the two by PO number, PO Item, Unit code and Delivery quantity.
This works fine until one PO Number has more than one delivery quantity which is equal. For example.... The PO quantity is 4,000 but, because the units can only be shipped in quantities of 1000, there are four different entries in both the DC and the GR tables each with the same PO number, PO Item number, Unit code and delivery quantity (and shipped on the same date). This of course gives 16 results for the query using this PO number.
There is one unique field in the DC table this is the posting number field. I've tried grouping by this number and taking the First values from the GR table. This works OK in that it produces Four results but, two of the deliveries were received on Day 1 and two were received on Day 2. If I take First of GR date I get DAY 1 for all, If I take Max I get Day2 for all. What I need is the correct date.
I hope I have explained this OK.
And I hope you can help
Hi I've been having this same problem for a while and I've had a bit of help here but none of the suggestions have so far worked.
Basically I need a way to stop people tabing through a sub form without entering data. The sub form has a check box that has to be checked (it can't be set as True as default) the required field doesn't work and for some reason the Enforce Referential Integrity on the join between the main table (tblCustInfo) and this one doesn't work either.
tblCustInfo = the main form
tblAgentData = subform
can anyone please help?
Hi can anyone help please!
I'm writing a course registration Db. I have a have 3 tables at the moment tblContacts [ContactID], [FName], [SName], [Etc..] tblCourseRegistration[RegID] [ContactID][CourseID] and
tblCourses[CourseID] [CourseName] [Etc...]
These are all linked on a tabbed form. I have found that the same Contact can sign up for the same course twice. I need to stop this happening. Is there an easy way to prevent this or do I have to write a query that runs before the save command to prevent this?
Thanks in advance person with sore head!
i wonder if anyone can help with this problem i cant seem to work out.
i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.
i want to stop the user being able to go past the last record in the orders table. or enable them to get back to the last order. currently if the user goes past the last record (making a new order) there is no way to get back to the last record. using the navigation back button causes errors as the required fields are blank and access tries to save the order, thinking i want to make a new one.
i hope this makes sense.
i have tried setting the Allow Additions setting of the Form to No. but this causes problems when there is no data in the orders table. opening the form produces a blank form, showing no fields or buttons at all.
i would be greatful for any advice, maybe i am doing something fundamentally wrong?:confused:
i wonder if anyone can help with this problem i cant seem to work out.
i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.
i want to stop the user being able to go past the last record in the orders table. or enable them to get back to the last order. currently if the user goes past the last record (making a new order) there is no way to get back to the last record. using the navigation back button causes errors as the required fields are blank and access tries to save the order, thinking i want to make a new one.
i hope this makes sense.
i have tried setting the Allow Additions setting of the Form to No. but this causes problems when there is no data in the orders table. opening the form produces a blank form, showing no fields or buttons at all.
i would be greatful for any advice, maybe i am doing something fundamentally wrong?:confused:
I will explain this situation using a scenario. Let's assumed that i'm
working on a library system where i need a loan form that will only
show books that are available for loan. In this case, this form has a
main form that shows library member's details and its subform shows the
details of the books that are loan by library member. In this subform,
one of the fields (ISBN no) displays its values using a combo box. Once
a value is selected from this combo box, values in other fields found
in the subform will be shown too. These values are based on a table
that contain books info, where only the value (ISBN no) in the combo
box comes from a query. This query will only show books that are
available for loan.
If a library member wants to borrow 'booktitle1' then this book will
not be available to be loan by other members and assumed that there is
only one 'booktitle1'.
I tried to update the field manually by changing the status field every
time the book is loan out. I hope to solve this problem in an effective
way.
I am new with access and i have difficulty to explain it in a much
better way. Sorry, if my description cause any sort of confusion.
These are the tables.
book_info (table1)
-------------------------------
bookTitle ---------- text
ISBN(pkey) ------- text
authorName ------ text
category ---------- text
dateReceived ---- date
publisher ---------- text
status -------------- text
user_info (table2)
--------------------------------
name --------------- text
userID(pKey) ------ text
address ------------ text
tel ------------------ number
hp ------------------ number
occupation -------- text
DOB --------------- date
loan_info (table3)
------------------------------
userID(fKey) ------ text
ISBN(fkey) -------- text
dateReturned ---- date
dateBorrowed ---- date
dateDue ---------- date
remarks ----------- text
Thanks.
Leah_603