Search results

Front end contains your forms, queries, reports, macros, modules and VB code. Back end only has tables. Tables store the data. When you split a db, you are creating 2 files. Both are Access databases. You the tell the FE where the tables are to be found. This is called linked tables. Once a...

I have this so far. Please note that I have done very little code and the table structures are not best practice yet. This is just an example of what I mean.

Table1 ID (PK) EmployeeName EmployeeNumber StartDate EndDate TerminationReason (FK-T2) Table2 ID (PK) TerminationReason Table3 ID (PK) AttendanceCode AttendanceType Table4 ID (PK) Date (Indexed*) Employee (FK-T1, Indexed*) AttendanceCode (FK-T3) * Duplicate Date ok if Employee not duplicate...

I have also being looking for an attendance db to replace a spreadsheet. I just can't find a suitable way to transpose the employee fields. Here is some code that I use in another db to create dates for a full month or range of dates. If also fills in missing dates. Just change the start and...

Maybe they would play a bit better if they changed the colour of their uniform. They all look like they are wearing full body Speedos. Guess that is fitting for Seattle weather. At least the Springboks just bet Ireland on Saturday.

Thanks Galaxiom. I reuse code a lot. I do not like using macros and prefer VB (especically when having yes/no message boxes). This will go a long way to redusing the clutter in my code.

If it is 2003 (guess by MDB extension) the edit the registry: HKLM\Software\Microsoft\Office\11.0\Access\Security "Level"=dword:00000001

'Delete existing linked table DoCmd.DeleteObject acTable, "Table1b" 'Link Table1a from BE and call it Table1b in FE DoCmd.TransferDatabase acLink, "Microsoft Access", CurrentProject.Path & "\Data\be.accdb", acTable, "Table1a", "Table1b", False First line of code deletes the linked table in the...

Why oh why is mod (supose int comes close), roundup and rounddown not included in Access as basic functions. Works a treat in Excel.

Has anyone written a tutorial in the code repository on reusing code?

Macros have very limited msgbox support. Better to do them in VB. ("First line of text." & vbNewLine & _ "Second line of text on new line" & vbNewLine & vbNewLine & _ "Third line of text in a new paragraph.")

http://www.createinstall.com/ allows you to run a macro based on a registry value.

I have a solution. This works for forms that you resize and loose their size. Open the form in design view. Make all the changes you need. Open any Event Procedure. Close the VB window. Close the form. It should ask if you want to save it. That's how its done.

Like finally being able to remove the cardboard cutout from the function keys and the coloured dots off the Shift, Ctrl and Alt buttons, but still using the function keys to do stuff. For you youngsters out there, Im talking about Word Perfect some 21 years ago.

Sorry keep getting disconnected while editing. Make sure you always save your DB as ACCDR. That way, even if they have Access the DB will always open with Runtime. You could also use one of the free installer packages available that has the otion to act on registry values. Make a Developer...

Download Runtimes and Developer (free from Microsoft) Developer will make install packages for you. It has 3 options: 1. Requires Access 2007 to be installed. 2. Requires Access 2007 Runtime to be downloaded if Access is not installed. (The file will be installed with the ACCDR file...

You are right. I have just always used it like that and thought that was how it was done. Never tried it, untill now, without the $. BTW I tested using dates in both Date/Time and Number formats. Both fields returned correct formating in A2K and A2K7. Now I just have to remember that I don't...

There must be a $ after format format$([Date1],"yyyy/mm/dd")

I take it that you still want to have the 3 seperate FE's and that occasionally you need to run the query. Three options: Just create a new FE and link the 3 BE's tables to it. Create your query in this FE. In each FE link all tables from 3 BE's. In each FE create the query. Now you can run...

Robocopy is a much better solution for copying files.