Want To Stop Execution!

Feb 12, 2006

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 !

View Replies


ADVERTISEMENT

How To Stop Query Execution At The Form Start

Dec 19, 2005

Hi

I am a new user to Access. I created couple of forms using wizard, but when I view them, they show me all the available data by default. I want to stop this, if anyone can help me plz.

RMA

View 5 Replies View Related

DTS Execution Via MS Access

May 23, 2007

Hi Folks,

I am wondering if it is possible to execute a DTS package via Microsoft Access. I have done a bit of research and cannot seem to really find anything that claims this is possible or how to go about to get it to work. I am running SQL Server 2000 which has quite a few DTS packages ... it would be really neat if I could just create a small interface in Access whereby a form has a few buttons on it that can be clicked and the DTS packages can be executed on the server, this way folks won't need to log on to the server and run the DTS packages via SQL Server Enterprise Manager. What would REALLY be awesome would be if values can be passed between SQL and Access but I think if that is possible it would be quite an animal to achieve (I know it is possible via Visual Basic programming but not really worth all the work to create an independent program just to run a DTS package or pass a value). If anyone can provide me with any information or where to look I would appreciate it.

Thanks,

Joe

View 3 Replies View Related

Form Execution Bug

Jul 3, 2005

Hi everyone,

This is my problem. Almost all the time(90%), I open the main form of my application and a large part of the form is blank(white). If I open it from the Database window it often work well and all the form is visible.

When the bug occur, If I just switch from Access to another application like Internet Explorer and I come agian to Access then all the form is visible.

Is someone ever seen that kind of bug. What that can cause that problem. How can I solve it?

N.B. There is a lot of controls on my form and I guess that bug can be linked with it. Seems like Access is trying to open my form too rapidely.

View 1 Replies View Related

Query Execution Time

Jan 3, 2006

I have a query, it joins a local table to a remote table (Oracle Database Table) which makes it slow(ish).

When I am in design mode and i click the "View Datalist" button, which visually shows me the results, the query executes in about 12 seconds.

When I use the "!" Button to physically Execute the Make-Table Query, it takes hours.

What things should i look for that might cause this problem? Where do I need to optimize.

To me it seems rather odd that the query would execute so fast when i view the data than when it physically executes the data.

Same speed problems when i just run the query as a Selection Query as opposed to the Make-Table Query, so it's not an issue of writing to disk/etc.

View 2 Replies View Related

Time Execution Question

Mar 14, 2005

Hi,

how can i create a comand button that open a form at predifined date?

example: if current date=2005/14/12(yyyy-dd-mm) then open form "example"


thnks,
Kopas

View 4 Replies View Related

Unsuccessful Execution Of SQL Statement Within VBA Codes

Jan 1, 2006

I have a problem about running SQL statement in VBA code. I will appreciate a looot if you can help me solve the problem ASAP.

I tried to run the following statement in my VBA code to update a table in my database:

DoCmd.RunSQL "UPDATE TBL_GRANTBASEDATA, TBL_QUARTER SET TBL_GRANTBASEDATA.Retire_QTR = TBL_QUARTER!QUARTER WHERE ((([TBL_GRANTBASEDATA]![Retire_Date])<=[TBL_QUARTER]![End_Date] And ([TBL_GRANTBASEDATA]![Retire_Date])>=[TBL_QUARTER]![Start_Date]));"

It turns out that the table will not be updated if I run the above SQL statement with my other VBA codes. (ACCESS doesn't give any error messages even though the database was not updated.) But if I run the SQL statement by itself rather than within the other codes, the database will be updated successfully. (When I set a breakpoint at the above SQL statement and run it manually within the other codes, the database are updated successfully too.)

Apparently, the SQL statement and the other codes don't have any syntax errors. I wonder why ACCESS doesn't execute the SQL statement when the SQL statement is put within the other VBA codes. Is it because the table it tried to manipulate was locked by the other codes?

The following are all the VBA codes including the SQL statement I'm talking about. When I run the following codes together, the database is not modified by the SQL statement (the last sentence). But if I run the last sentence and the other codes separately, the database was modified successfully.


Dim rstDataLoad As New ADODB.Recordset
With rstDataLoad
Set .ActiveConnection = cnnSHELL
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Source = "SELECT TBL_GRANTBASEDATA.* FROM TBL_GRANTBASEDATA;"
.Open
End With

'Calculate Retire_Date
rstDataLoad.MoveFirst
Do While Not rstDataLoad.EOF

Calculation omitted.

rstDataLoad.MoveNext
Loop
rstDataLoad.UpdateBatch
rstDataLoad.Close
Set rstDataLoad = Nothing

DoCmd.RunSQL "UPDATE TBL_GRANTBASEDATA, TBL_QUARTER SET TBL_GRANTBASEDATA.Retire_QTR = TBL_QUARTER!QUARTER WHERE ((([TBL_GRANTBASEDATA]![Retire_Date])<=[TBL_QUARTER]![End_Date] And ([TBL_GRANTBASEDATA]![Retire_Date])>=[TBL_QUARTER]![Start_Date]));"

View 4 Replies View Related

Wait For Shell Execution To Finish?

Jun 19, 2007

I'm using hte Shell() function but this doesn't wait for the executable file to finish so I'm looking for a command line function that would wait until the executable file is finished executing...

I saw this function WaitFor but it is not supported in MS-Access? So, what do I do?

Thanks...

View 7 Replies View Related

Modules & VBA :: Call Value From A Text Box During SQL Execution

Dec 20, 2014

I have this segment of code that adds data to fields FName and FPath in the table Files. It works fine but the syntax is a nightmare with all the double quotes and symbols.

Code:
strSQL = "INSERT INTO Files " _
& " (FName, FPath) " _
& " SELECT """ & strTemp & """" _
& ", """ & strFolder & """;"
CurrentDb.Execute strSQL

I have another field in the table Files called CompletedBy that shows who updated the table (they type their name into a textbox Text1 before clicking a command button to run the code). I would like to add this data to the table during the execution of strSQL. All the records added to the table Files will have that value in the CompletedBy field (say, Bob Jones).I tried the below changes but the code doesnt work.

Code:
strSQL = "INSERT INTO Files " _
& " (FName, FPath, CompletedBy) " _
& " SELECT """ & strTemp & """" _
& ", """ & strFolder & """ & Me.Text1 & """;"
CurrentDb.Execute strSQL

How would I add a value in field CompletedBy, from the textbox Text1, to all records added to table Files when the code is run?

View 2 Replies View Related

Query Execution And Record Modifying

Dec 8, 2014

whenever I run/execute a query in Access it is modifying the first record on the table in which it is calling the data from.For example if the first record might contain the following:

Record A: John Doe, Oct, 2014, Account is Active

And lets say I am running a query to pulling records from Nov 2014.The Month and Year Fields in the above example for Record A gets modified to the query search parameters for Nov.Is there some of of record lock or controls that I need to adjust to prevent this from occurring?

View 1 Replies View Related

Disable Datasheet From Poping Up After Query Execution

Sep 24, 2007

I am trying to take input for my reports based on a query result dynamically for which i dont want to display the Datasheet after the execution of Query ,inturn i am displaying results in Report. Any help on this would be appreciated.

View 14 Replies View Related

Forms :: How To Force Execution Of A Query When Changing Record

Jul 13, 2014

I have the following tables:

Supplier
Supplier# [Other columns]

Material
Supplier# Material# [Other columns]

DeliveryHeader
Delivery# Supplier# [Other columns]

DeliveryDetail
Delivery# Supplier# Material# [Other columns]

I've created a form based on table DeliveryHeader with a subform based on table DeliveryDetail. The two are linked by Delivery# Supplier#.

On the form, Supplier# is a combobox that lists all suppliers from table Supplier.
On the subform, Material# is a combobox that lists only the materials supplied by the supplier selected with form's Supplier#.

The problem is that this second list always shows the materials of the first listed supplier. For instance, when the form is loaded, it shows delivery #1 with all its details on the subform. Suppose supplier loaded to form is #1.

1) If I use subform combobox, it shows correctly supplier's #1 materials. But then, whatever delivery I navigate, it always shows supplier's #1 materials.

2) If I navigate to another delivery without using subform combobox, suppose I stop on a delivery where the supplier is #4, then subform combobox shows correctly supplier's #4 materials. But then, once again, whatever delivery I navigate, it always shows supplier's #4 materials.

I've spread Me.Requery here and there but without any success. What trick must I apply to force the execution of the query of the subform combobox Material# each time I navigate to a new record on the form?

View 4 Replies View Related

General :: Pop Up Process Running MsgBox And Close Automatically On Execution

Aug 23, 2013

I have a form that loads when the database is open, and the form has buttons etc. that leads to queries and reports in the database. (Queries open in a form). Since most queries take a while to load, I was wondering if there is a way to Pop up a message box stating "Please Wait, Query is running..." (or something like that), and once the form opens the MsgBox should close automatically. (The user should not have to hit Ok button.)

Most users of this database would have restricted access such that they would not have navigation pane and toolbar visible - hence I want to make it a touch more interactive when a process is running...also if someone is new to access they might not notice that taskbar status and I don't want them thinking the program is stuck etc..

View 4 Replies View Related

Modules & VBA :: Excel File Opens And Code Stops Execution

Nov 12, 2014

I'me running on Win7, Office 2010, Acc2003 format (.mdb), writing data to Excel 2010 (.xlsx)I have code to create an Excel file, send record set data to it, and then add some formulas and formatting. I was trying to tune up the formulas, when I got a pull back:Access VBA code suddenly stops running, and the file gets displayed in Excel

Code:
'ApXl is Application.Excel
'xlWSh is the Excel WorkSheet
'rst is my DAO.Recorset

[code]...

The same happens when I have ApXl.Visible = True

View 10 Replies View Related

Stop Booking Twice Help Please!

Apr 22, 2006

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!

View 1 Replies View Related

Sigh... STOP!!!

Jul 12, 2007

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 Related

Stop Me Flicking

Jun 22, 2005

I 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

View 2 Replies View Related

Stop Warning

Oct 18, 2006

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 ?

View 11 Replies View Related

Best Way To Go About This, (stop Duplication Of Entries)

Aug 8, 2006

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

View 10 Replies View Related

Message To Appear But Not Stop Macro

Jul 6, 2007

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

View 1 Replies View Related

Stop Closing Form

Jul 25, 2007

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.

View 1 Replies View Related

How To Stop Repetative Typing

Jun 9, 2005

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:

View 2 Replies View Related

How To Stop Duplicate Records

May 2, 2006

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

View 6 Replies View Related

Help To Stop Bypassing A Sub Form...

Nov 18, 2005

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?

View 1 Replies View Related

How Can I Stop The Same Record Being Saved Twice

Feb 25, 2006

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!

View 7 Replies View Related

Stop Form Going To New Record

Jun 27, 2006

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:

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved