Is that all of your code? Have you debugged your code to see what lines of code processed prior to the form entering the 'Not Responding' state?
I'm no expert, but you may be having trouble because either (1.) your thread isn't allowing for enough time in relation to the progress you're trying to update on the label or (2.) the progress/update isn't actually being performed in a separate thread.
Like I said, I'm not expert...
beacon
Last Activity: Jul 9 '13, 05:11 PM
Joined: Aug 16 '07
Location: Your Mom's House
-
What is the best way to implement server to server communication?
Hi,
[C# .NET 4.0]
I'm looking for a way to automate a number of things at work to make my life easier...not because I've been told to, just because I want to. I've been learning C# for a few months now and I've been looking for personal projects to help facilitate that and I'm hoping my question today will eventually become another one.
One of the things I'm looking into is a way to run basically the same... -
I figured out what I was doing wrong. First, I was doing the right thing by setting the parameter through the QueryDef object, but I was trying to open the recordset based on the database object, not the QueryDef object I just created.
...Code:Set qdf = db.QueryDefs("Table 01 P3") qdf.Parameters![Enter Provider] = strProvider Set rs = qdf.OpenRecordset With .Range("A11")Leave a comment:
-
How to pass a parameter to a query that a recordset is based on?
Hi everybody,
[Access/Excel 2010]
I'm trying to automate the creation of some Excel workbooks using the CopyFromRecords et method. However, the recordsets that I need to send to the Excel workbook are based off multiple queries, all of which have a parameter in the lowest level of the query.
So, for example, I'm trying to send the results of a crosstab query to Excel. The crosstab query is based off of... -
Thanks NeoPa. I thought about that, but really needed, and appreciate, the confirmation.
Thanks ADezii...I knew the object shouldn't be declared/instantiated for each call of the routine (where the same object is open and used throughout).
However, it does raise another question (again, I think I know the answer, but appreciate the confirmation to write it to my personal harddrive, i.e. my brain). Is...Leave a comment:
-
Help understanding object instantiation using automation
Hi everybody,
[Access/Excel 2010]
I have a database that I'm using to generate an Excel workbook with 13 worksheets for a list of 50 or so contractors. I have a subroutine that loops through a list of providers, creates a new workbook, adds the 13 worksheets, and formats cells. Soon, I will be calling multiple queries and placing the data into specific cells in each worksheet in each of the workbooks for the contractors.... -
@NeoPa
Were you able to get it to work for my example? I've tried the Eval() function a couple of different ways, such as passing a string/variant to the subroutine and using that variable in the Eval() function with the Call statement (I get error 2482 - Microsoft Access cannot find the name 'SelectProvider s' you entered in the expression).
...Code:Public Sub StartSub(strSubroutine As Variant)
Leave a comment:
-
How to call a sub/function using a variable holding the sub/function name?
Hi everybody,
[Access 2010]
I'm not sure if this is possible or not, but I wanted to check to be sure.
I'm working with a database that depends on running a bunch of tables through a number of different queries (including make-table queries). This happens a number of different times throughout the database as data is compiled for different sections.
Due to the inefficiency of this process,... -
I'm just working with modules as a way to iterate through different collections of queries (basically to change the source for the query) and export some of them to Excel.
I think you're right about the TransferSpreads heet method shelling the event to Excel, which is fine so long as the shelled event isn't affected by the VBA code going to the next line. The next line is usually the next iteration in the For..Loop, which is usually...Leave a comment:
-
Does VBA complete tasks asynchronously?
Hi everybody,
[Access 2010]
I've seen conflicting answers online, so I thought I'd see what answers I would get here.
If I have a VBA module that has code that sets multiple variables to different QueryDefs, assigns SQL to the SQL property of the QueryDef, and either executes the QueryDef or exports the query using something like DoCmd.TransferS preadsheet, will each line of code run and not progress to... -
I have a follow up to this that I'm hoping someone can answer. I had the following line in my code:
...and when the subroutine completed, the tables created by the Make Table query are still hidden or, at least, don't show up in the Navigation Pane.Code:For each t in td
When I change the line to:
...it appears to...Code:For each t in CurrentDB.TableDefs
Leave a comment:
-
Never mind...I figured it out. For some reason I used:
...instead of:Code:Dim t as Object
I don't have any clue why I used Object instead of TableDef,, but, as is usually the case, as soon as I post something here I see the error.Code:Dim t as DAO.TableDef
Thanks,
beaconLeave a comment:
-
How to avoid inadvertently hiding tables when using Select..Into?
Hi everybody,
[Access 2010]
I'm not sure if the subject will ultimately describe my issue, but it was the best I could come up with based on the info I've got.
I'm working on a database that I inherited from a previous employee and it's very basic, at least in terms of objects...there 's only tables and queries, no code. However, the queries depend on other queries in order to perform their functions, i.e.... -
Hi,
Welcome to Bytes!
What you're trying to do is simple enough, but it can be somewhat daunting if you've never done anything like it before.
The first thing you need to do, with your form in Design View, is click on the combo box and navigate the properties (right-click and choose Properties if your properties aren't immediately available) for the AfterUpdate event. Click the dropdown, choose Event Procedure,...Leave a comment:
-
Thanks for taking the time Smiley...I'll try to clarify a few of the things you had questions about.
IsNothing is a custom function I use that checks for null, empty, zero, and a couple of other conditions that might cause a value to be "nothing", per se.
This was a typo that I missed when asking my question. I had tried a bunch of different things and failed to change prog to Program,...Leave a comment:
-
The short answer to your question is yes, it is possible.
You will have to add the Click event to your command button. I'm going to assume a couple of things about your form, the fields on it, and the table you're using. Keep in mind that you'll need to change my assumptions to match your naming conventions in your database.
...Code://Assumptions Command button name: cmdStatusCheck Field to check: txtStatus
Leave a comment:
-
Have you tried dropping the "Me.wasextensio n2.Value = 'Y'" to the next line and adding an "End If" on the line after so it looks like this:
I'm not sure if this will make any difference, but it's worth a shot.Code:Private Sub Frame219_AfterUpdate() If Me.Frame219.Value = 1 Then Me.wasextension2.Value = "Y" End If End Sub
...Leave a comment:
-
How to pass a subreport field to a standard module function?
Hi everybody,
[Access 2010 .mdb]
I'm working with a report and I'm trying to create a standard module function that will reduce the amount of code typed into expressions on the report (since the expressions are essentially the same, save for one piece of info).
On the report, there are 11 text boxes that are identical that I've named Col1, Col2, Col3, etc. These text boxes have the following control source,... -
beacon replied to How to create a custom shortcut menu command that identifies the calling form/report?in AccessThanks for the replies. Mike's suggestion actually led me to a solution, which I will provide below for anyone that wants to create a custom shortcut (right-click) menu in Access 2010 and wants to use a custom function attached to a command/control button. I may have caused confustion by referring to the button as a command button previously...af ter looking at the original example, I think it's called a control button since they are referenced as...Leave a comment:
-
beacon started a topic How to create a custom shortcut menu command that identifies the calling form/report?in AccessHow to create a custom shortcut menu command that identifies the calling form/report?
Hi everybody,
I'm using Access 2010, but the format for the database is .mdb because I'm not ready to fully convert it to Access 2010 and the .accdb format.
I've been reading up on how to create Shortcut Menus in Access 2010 using VBA and I'm pretty confident I understand how most of it works...meaning that I can create a custom shortcut menu, register it (for lack of a better term) so it displays in a form's/report's...
No activity results to display
Leave a comment: