Search results

Hey Boyd ... >> Macro just is not powerful enough. << Since this was posted in Excel ... I am thinking the OP is meaning a VBA prodedure ... not an Access Macro ... :)

This is a LOT of effort for something that Access can do inherently.... Simply set your "Record Locks" property to "Edited Record", this will invoke Pessimistic locking, and AS SOON AS a user begins the edit of a record, the JET/ACE database engine will lock the record and prevent ANYONE else...

I just posted the attached utility in the Code forum, but It is not visible yet ... so ... give this a shot ... the app is in A2000 format, however, you can interrogate A2007 files as long as you have the MICROSOFT.ACE.OLEDB.12.0 provider on your system.

... Hmm ... Did you get this figured out? ... or is it still running fine ... My first question would be .. IS there a control on the form named "Asset"? ...

Do take note that lookup tables (often called Domain Tables) are not evil! ... The subtlety that is easy to overlook for folks learning about databases is that defining your lookup definition at that Table level is not the way to go, BUT ... use of lookup tables (domain tables) is definately...

Or ... a regionally independant method ... Me.YourControlName.Visible = (WeekDay(VBA.Date,1) = 5) ... if you prefer to use constants ... Me.YourControlName.Visible = (WeekDay(VBA.Date,vbSunday) = vbThursday)

As an alternative, I would suggest you look at the code found here: fNetWorkdays() and fAddWorkdays() To get the previous workday of a given date you would simply call fAddWorkdays(somepasseddate, 0) All the holidays are table driven, thus allowing for complete flexibility.

When you say "Database" do you mean "Table" ... and you have a single database with two tables you wish to compare? ... or .... do you have two completely different databases and you are wanting a table from one to a table from the other?

Boomslanger ... I would suggest that you use DCount() against the TABLE and NOT a query, just enter your criteria in the third argument ... (my sample ASSUMES, [Asset] is a TEXT datatyped field) =DCount("*", "tbl_Assets", "[Asset]='" & [Asset] & "'")

I beleive the issue you are experiencing is due to the value that you do not have a space between the WHERE and the table name in the code you have posted, in addition, I assume the value you type in txtCustomerName is a TEXT value, and as such needs to be delimited in the SQL statment you set...

>> Personally, I think I'd rather just make sure that I'm not using any code that spawns an unwelcome instance of Excel. << You are correct. My first exposure/use to the KillProcess code was in an enviroment that only used Excel as a reporting tool. The user could not even open Excel on...

Hello DCrake ... >> Can you please elaborate more on what the KillProcess does << I found the code on the internet as I was dealing with a pesky persistent Excel instance. The project I was working on was a contract job so thorough code analysis was not possible, so I implemented this code...

... Oh ... Even though I indicated in my code to use the Selection object, MOST often it is DISCOURAGED to do so! ... you can usually work directly with stuff more efficiently... In other words .. your 'work around' is actually better code than the 'fix' I provided to fix your error ...

I know you have created a work around, but I wanted to tell you why your original code was failing ... You are running this code from ACCESS, also, many times an Excel process remains in Memory with manipulating the Excel app model. With that, the Selection object does not seem to know how to...

Oh my! .... I must apologize ... I have had this post on my screen since the wee hours of the AM ... the last post I saw was the Relationship Diagram .... So ... much conversation has occurred since then and I am sorry to post duplicate information ... I left my second post on the thread in the...

Your tables are not designed well ... specifically, your Program table is not good. You need to separate that into two tables ... Program ---------- ProgramId (Autonumber, PK) Program_Code (Set as a key field for a Unique Index) ProgramDesc ExcercisedArea ------------- ExcercisedAreaID...

>> I want to have them in another form with other feilds to be edited. << Forms can be bound to a RecordSource (ie: a Table, Query, or SQL Statement) via the forms RecordSource property. With that, your controls on that form can be bound a control (ie: a Text Box) via the use of the Control...

I respectfully disagree .... You can not save it if you use the QBE to create SQL statement RecordSource properties, but Access Query Object retain there "form" between editing sessions. You simply lay it out the way you wish, then hit CRTL-S to "Save" the Query Object (or you can choose save...

The most proper way to do as you are wishing is with proper JOINS between the tables .... Would you care to share your table stuctures as well as as small snapshot of data for those tables?

The task you seek to perform is a relatively easy one, but why would you want to create blank records?