Search results

That checked out well and the outcome was what I was expecting/hoping. So just by opening access with none of my VBA/Macros/Forms active: Debug.Print DBEngine.Workspaces(0).Databases.Count This returns 1 and then each additional SET adds another database object to the databases collection Dim...

Cool cool, thanks Doc. I'll check this out as soon as I'm back in the office tomorrow. First thoughts are if I need to Dim x as DAO.Workspace and if it is still relevant in latest Access build version. Just thinking out loud not asking anyone to put in the legwork. I thought Workspaces were...

Hey AWF, Hypothetically if I have a form event that had a Private Sub PlaceholderNameRoutine_Click() Dim db as DAO.Database Set db = currentdb() 'call function(i) TestMyCurrentDB1 set db = nothing End Sub Which called 9 other functions in a module/subs such as TestMyCurrentDB2, 3, 4, etc -...

It should be this since you need to join the variable into the SQL statement. strSql = "SELECT * FROM [PoolBookings] WHERE [BookingID] = " & LastID & ""

This works for me with linked SQL Server tables. Dim db As DAO.Database Dim rs As DAO.Recordset Dim rs2 As DAO.Recordset Dim Form As Integer Set db = CurrentDb Set rs = db.OpenRecordset("tbl_users", dbOpenDynaset, dbSeeChanges) Dim fld As Field Dim idn as LongPtr...

You may also need to add dbSeeChanges as a recordset option when working with SQL Server. Set rs = db.OpenRecordset("tbl_users",dbSeeChanges) or Set rs = db.OpenRecordset("tbl_users",dbOpenDynaset, dbSeeChanges)

Looking to implement it on an Access Form. That was what was used in the example resource as well.

Hey AWF, I'm looking for an old post and wondering if it rings a bell in anyone's head on where to find. Can't remember if it was an AUG group, forum post.. I do think the example used was Microsoft's webpage where you have your header as such: And then on clicking one of the header items...

As @MajP said - if your field headers really are 1.3.9 , 1.4, etc then you can't use those values as field names / column headers. You would have to replace the "." and change to something else such as 1_3_9 , 1_4 , etc. You can have field names with "." in them in SQL Server. You can not in MS...

Is it always going to be the same 3 tables that you are generating your insert statement from, and why 3 tables? Is it always 3 or sometimes more/less? It would be pretty cool if all 3 tables have the same structure to make them 1 table. Instead of tbl_A: Field_Heading Area 1.3.9. 651...

@Pat Hartman I'm using it to fix Access BE tables before migrating to SQL server, and was working to automate it. I have a lot of db's to migrate and some are +200 table databases where it is a mix of not having PK or AutoNumber, some have AutoNumber with no PK, or PK and no AutoNumber, or...

I've been using something based off of code MajP shared. This is only using one table versus the three you mentioned in your post, but could maybe be a starting point. In the function below strTable is my source table, and nstrTable is the new/target table. post here...

For the personal - 2022 Lenovo Legion 5 Pro RTX 3070ti & Ryzen 7. Waiting on the good deals to snag some desktop parts or the Nvidia 50 series cards drop and 40/40 super series become cheaper. For the work - 2022 HP Probook 440 G8. It gets the job done.

Once you put your breakpoint by clicking to the left on your code, go back to your SaveFinalAuth_Click on your form, and your code will stop at this line. Then F8 to walk through. You can put another breakpoint further down in your code and instead of having to F8 all the way through it, press...

Agreeing with Minty.. all my db's have oMail.send '.Send or .display

I don't know if I get it either.... Honest. In your example: "(DRWG VIEW T-T) [***-0A244-1*" This would like be updated to some of the following "(DRWG VIEW T-T)" "(DRWG VIEW T-T) [***-0A244-10=***]" "(DRWG VIEW T-T) [***-0A244-20=***]" But there is no need to go to a different task and select...

tblSpec_inst is 1:M to tblTask Each spec may be part of many tasks.

Right now 7,000 unique SI that are being shared among the 150,000 task records. Of the 150,000 tasks - 10% have no SI, 89% reuse SI, and >1% (639) of tasks have a SI unique. That >1% (639 tasks) is the user editing the special instruction text. Most SI is automatically handled by the db through...

I'm checking this out now @MajP, thanks! I like the concept, and I hear and nod my head at the points being made. The task screen looks like this currently. Users aren't searching much for [special instructions] but it was made a combo so that the text could be reused and referred to by its...

Thanks Tom 1st point comments - the spec_inst stands for special instruction for the task. In the actual db there is also a task_text field. So it is more like Task = Fix Engine, Task_Text = Do these 20 steps, Spec_Inst = (sometimes no spec_inst for the task) but verify/confirm 'x' Made up...