Recent content by G37Sam

add a dummy field call it (RowOrder) and order your records however way you want them displayed

here you go, you can run ifs and conditions to choose which backend you want Dim tdf As TableDef Dim strBackEnd As String For Each tdf In db.TableDefs strBackEnd = "INSERT YOUR DATABASE LINK HERE" Set tdf = db.TableDefs(tdf.Name) tdf.Connect = strBackEnd tdf.RefreshLink Next tdf

I could not agree more with this! The only real way to learn is to work on a project, a course is good if you're completely new to Access & VBA (as in, only know how to double click on the MS Access Icon). Most of my learning actually came from reading/interacting on this site believe it or...

Something like this? SELECT Postcode, CustomerID FROM Model_Elec UNION SELECT Postcode, CustomerAC FROM Model_Elec1

on the form itself, just do =[GSMID] it will help if you share a sample database

The real question you should be asking yourself is, why are you duplicating this data? Can you not just have them link to the same source? AfterUpdate only updates after the table is updated On_Change could also work, but this will require use of [field].text property to capture the actual text...

You need an ID field in your Regen table - Using DAO: open that table in ascending order of that ID, scroll to the last record and then goto the previous record. Another way is to use DMAX(RegenID,tblRegen) -1 but you'll have to make sure the ReGen ID increments 1 at a time using the...

Then it should look like this Fee Account table Fee ID Fee Description Fee Amount

next to Cheque Profile, theres a folder icon that opens the profile editor You will need to hold CTRL button to drag, it was misbehaving without CTRL

How many different kind of fee's do you have? Do you want to allow your user to modify fee types in the future?

Database attached for reference and comments

Add the database path to the Trusted Locations File -> Options -> Trust Center

Yes - I am only doing this with one report, thats the whole point :) The x's and y's of each field change dynamically depending on the user-defined cheque template. I will upload the final database once done for your reference and comments.

Oh man - you've given me enough learning to keep me busy for a few weeks! Will study this and get back to you if I have further questions. You're a hidden gem of knowledge MajP, thanks again for your time and efforts.

I'd just use: DCount("*", "MSysObjects", "Type=-32764") :D