Search results

I'm curious to know, is there some way for the Form load event to cancel its own opening process? Scenario in form 1, a button is clicked to open form 2 Form 2 has an on load event to populate the necessary information fields in form 2 The on load process for form 2 determines there is no...

Thanks!!!!

hmmm, I wonder if this is a localization problem? Are you running english OS and Office? ?Is your system delimiter a comma or a period? Does your msgbox fire? Have you tried changing the numbers to achieve different colors for testing purposes?

I've tried searching around, but either I'm not using the correct words, or it does not exisit, or is burried too deep for me to find it. Is there a way to force validation of a variable down to the case level of the letters? Such as what would be used for passwords? Capture a string value...

Well, it seems likely, based on your last post, that the form is based directly on the table. The actual VBA depends on your actual usage, but an example flow might be something like this: (Add a table: tbl_Record_Monitor with fields such as Process_ID(Primary key), Record_ID...

This could depend on when you want to write data to the table. If you don't want to write data until AFTER the record is complete, one solution, amoung many, would be to add a checkbox to the table. When a user is assigned a new record, the check box is set to true. Then subsequent users...

You may have already figured this out, but I think you answered your own question...

sigh, it appears the current version, 1.73, is x86 only... I have a x86 partition and will install it there, but I live mostly in the x64 environment these days...

Thanks for the tip, but we use BING BING BING! http://www.bingiton.com/Landingpage.aspx?form=&publ=&crea=

I'm not sure if "Audit" is the correct or best word, but does anybody know of a way to clean a database up? I recently inherited a database for upgrade to x64 Access and a lot of it was just running DoCmd action queries in temporary tables. It worked, but was very basic and very slow. So I...

I assume there is some missing code, otherwise there are two too many End If lines but that should generate an error of its own. Can you fire a msgbox to show your record count in rst1 right after .movefirst? Is it possible the values to update are already the same as the values you are writing?

In fact, that is actually how I got the source SQL originally. However, I actually added the WHERE clause manually. Just to make sure I did not damage anything, I have taken it back to Access in a blank query in SQL view and got the same error! So I again created a new query in design view...

I added this question to another thread I started last week for a different problem, but since that problem has been resolved, I think it might be better to start a new thread with this new problem. For some reason, this db.execute statement is generating a "Syntax error in FROM clause" error...

In your code, you are basically just importing and doing file management. To actually edit the Excel file, you'll need to operate Excel from Access. You'll first need to create an Excel Object within your Access code to be the source file. Once you're in, the cell management functionality is...

The short answer is no. Access Tables hold values and values only. The values can have certain value type formats applied to the columns, but not the formats to which I beleive you are referring. To apply something similar to Excel's formulas in Access, you would need to have the source values...

I'm not sure if you're still working on this or not. Your pasted code includes this line: .Workbooks.Open (sFullPath) Your new line would need to look something like this: .workbooks.Open(sFullPath,, True,, [Password]) Of course, you would need to set a password on the actual Excel file.

well, you caught me, a little. The Customer_Number_VBA value is obtained in a different function. Technically, it is a Public variable, I just addd the Dim line to the posted code so you could see I was creating it and the type applied to it. Thanks for the idea on running the SQL! But, using...

Function Open(Filename As String, [UpdateLinks], [ReadOnly], [Format], [Password], [WriteResPassword], [IgnoreReadOnlyRecommended], [Origin], [Delimiter], [Editable], [Notify], [Converter], [AddToMru], [Local], [CorruptLoad]) As Workbook In the actual file, I think you'll want to apply a...

I know this is sitting right in front of me, but for some reason, it is eluding me... Running Access 2010 x64 on Win7 x64 Function Pull_Existing_Payments() Dim ws As Workspace Dim db As Database, rs As Recordset, rsFiltered As Recordset Dim Customer_Number_VBA As Double Dim Trans_Num_VBA As...

well, nothing a sledge hammer can't fix. I imported all of the objects in the main DB to a new and clean ACCDB and so far, I am able to delete, cut, and paste objects. However, I would still like to know what went wrong or what was changed with the original ACCDB. Any ideas will be appreciated.