Search results

I include accdr as an option as this is a version that could get distrubuted with Runtimes to users who don't have Access installed. As far as I'm aware you can't edit with Runtimes, only run the aplication. I know that Runtimes can read the other formats, its just the way I package my apps...

Try using If (Nz(Me.PROD, 0) <> 0) then instead of If [PROD] <> "" Then Also, why are you using a datasheet? A Tabular Form is much more customisable.

Split DB into FE and BE BE = Tables FE = Forms, Queries, Reports, Macros and Modules Password protect BE Link tables in FE It will as for password when linking Users cannot open BE directly or link tables to another FE without password Create forms and reports to display data In forms you...

make the db a mde, accde or accdr

Private Sub cmdClose_Click() Dim Msg, Style, Title, Response, MyString Dim Cancel As String If ((Nz(Me.WithDrawAmount, 0) = 0) Or (Nz(Me.Description, 0) = 0)) Then Msg = "Are you sure you want to discard this entry?" Style = vbOKCancel + vbQuestion + vbDefaultButton2...

Office Button Access Options Current Database Document Window Options Overlapping Windows

From the Access help file

Correct setup as you explained. Whether the tables are linked or not makes no difference to Access. As far as Access is concerned they are in the same database.

Silly question, but are your tables linked?

Check that OWC11.DLL exists on that computer. Look in c:\Program Files\Common Files\Microsoft Shared\Web Components\11

SELECT DISTINCT Table1.Field1 FROM Table1 ORDER BY Table1.Field1; Where ever you enter the data make an AfterUpdate Me![Combo1].Requery

In 2007 I use the USysRibbon table to control the Ribbon. Hide almost everything in the ribbon. Only Close is left. In the Access Options, Current Database use MyHide as the ribbon name. MyHide <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon...

(Int([Field1])*60)+(([Field1]-Int([Field1]))*100) Take the full hours and make them minutes (x60) Take the decimal minutes and make them minutes (x100) Add the two together. Int([Field1]) = Full hours [Field1]-Int([Field1]) = Remainder after number is divided by a full hour, i.e minutes in...

*** First day of month *** DateSerial(Year(Now()), Month(Now()), 1) *** Last day of month *** DateSerial(Year(Now()), Month(Now()) + 1, 0) Relace Now() as needed. Suggest that you have a ComboBox that gets the months from your table. Month: Format$([Table1]![Date1],'mmmm yyyy') A second...

Don't allow the users access to the tables. Suggestion: Split your DB into a FE and BE. Password protect the BE. (if someone does find it they can't open it) Link the Tables to the front end. It will ask for the password to link. Disable Shift At Startup. Hide Navigation Panel. Set a startup...

Are those 300 "lines" already records?

Have a look at: http://www.mvps.org/access/datetime/date0012.htm

You can use AND in conditional formating Expression Is [Date123] < Date()-7 AND [AmountDue] > 0 Then make an unbound text box next to Amount Due and use the code from Kryst51 to display the message.

Create a new FE(a new database with linked tables to the BE). Create a Delete Query. Create a Form with an On Load Procedure that runs the query then closes the FE. Make this VB not a Macro. Install Runtimes on the server. Copy the FE to the server. Use Scheduled Tasks to run the FE every day...

Data is stored in a "raw" format in tables. By that I mean that tables only collect data, they don't process the data. Queries (forms and reports use queries to display data) are where the data is processed and this is "on demand". If the table had to do the processing, the database would spend...