Search results

Why not just get ride of the Excel files all together and just use Access. Basically Access tables are very simple spreadsheets. Forms, queries and reports are used to enter and display the data. So instead of having hundreds of Excel files you have one DB. Further to that is that everything is...

Sounds like you never slit the app into a Front End and Back End. The FE resides on every client pc that uses the app and has all the forms, queries, reports, moduals, macros and VBA. The BE tables are linked in the FE. The BE resides on the file server and contains only the tables (i.e. just...

Oh, no. I have a problem. Refere to the screenie I posted. The main form is always in the background. If I click on the "Enter Data" button I will get a popup form (popup + modal =yes). On that form I have a button that opens the report in preview mode. The code does not work in this situation.

see http://www.access-programmers.co.uk/forums/showthread.php?t=202399 for further developments on how to turn the Ribbon print tab back on for reports. The Main form should not be a popup/modal. Forms that open from the main form should be popup/modal. The main form will then remain in the...

ALWAYS make your app, at least, an accde. Even better is to rename your accde to accdr. This forces The app to open in Runtime which disables the Shift and F11. Users can still rename the file accde though. Just one more layer to ward off the EBKAC errors.

Was looking for no ribbon/toolbar except for reports. Looking for this look for the app and just a print ribbon when previewing a report. Looks great. Thanks. I see what you did with the Got Focus on the main form and the USysRibbons.

Something like this?

I have the following code in my "switchboard" On Open procedure. For reports I have a custom ribbon (via USysRibbons). It is the standard print ribbon. Reports open in print preview. DoCmd.ShowToolbar "Ribbon", acToolbarNo I need to turn this ribbon on when the report is open. The following...

Assuming the Windows user account that opens the app as the required permissions to change the registry. Easy when a computer is part of a network as this can be done from the server. How to set or change registry editing permissions in Windows XP or in Windows Server 2003 And/or the AV...

Why not remove the Ribbon comletely and create buttons for the actions you would like the user to have. Private Sub Form_Open(Cancel As Integer) DoCmd.ShowToolbar "Ribbon", acToolbarNo End Sub Or create your own Ribbons using the USysRibbon table.

Please pm me for password. The graphs don't work yet and some of the avg and sum are a bit out. But the idea is there. Make sure you have the db in a trusted folder.

There has to be 2 BE's because we use cell phones to connect to the internet using GPRS which is slooooooow. We have no dsl or 3G and the data caps are extremely low. The price of living in rural third world. We visit each others farms at least once a week. Hence the sneakerware (maybe I could...

Maybe I should attach the DB. I'll do it tomorrow. It will be password protected. If you want the password I will PM it.

I have 2 extra sections in the DB that have combined figures and compare figures.

I had written "identical" queries to read the two datasets. I didn't know how to do that, but I am looking into it learning it. The basic setup is: Select farm Click menu button (form opens as per farm selection) Form is: Header = month/year dropdown (query dates from "main" table, converts...

The DB has 2 BE's. One for each farm. Reason: replication is done using sneakerware. One farm doesn't edit the other's data. The FE has duplicates of each form, just the references are different so as to use the correct BE. i.e. F_1_DateCheck and F_2_DateCheck. I would like some help on the VB...

On save button or form exit button. Dim Cancel As Integer If Len(Me.Field1 & vbNullString) = 0 Then MsgBox "A Number is required", vbExclamation, "Missing Data" Cancel = True Me.Field1.SetFocus Else 'choose Save or Quit depending on the button...

Check for duplicates Private Sub Field1_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("[Field1]", _ "Table1", _ "[Field1] = """ & Me.Field1 & """")) = False Then Cancel = True MsgBox ("The number " & Me.Field1 & " already exists." & vbNewLine & _...

New record, Field1 cannot be null/empty. Prompt as field looses focus. Private Sub Field1 _Exit(Cancel As Integer) Dim Msg, Style, Title, Response, MyString If Me.NewRecord And Len(Me.Field1 & vbNullString) = 0 Then Msg = ("You have not entered Field1." & vbNewLine & _ "Do you want...

Glad to see that works. I guess that the best way to transfer data from one DB to another is to use a DB file. That way it doesn't matter what language you are using. Remember to add the following: Backup procedure before export Empty export file before export Delete record from source after...