Search results

Hello again. I would like to ask if there is a way to display the toolbar or custom toolbar options, when create a runtime distributalbe MS Access database. For example I would like to have the backup database option available, when i make my project as a distributable runtime program, as well...

Is there a way to make a form/subform in datasheet view, be more 'compact' ? When I say compact I mean, smaller fonts, smaller 'boxes', etc? Excuse my bad english, I hope you understood what I mean.

Am having a slight problem here. Am trying to use 3 exact values as Criteria in a query, but it seems it not working, only 2 appear (the 1st two). I've attached a screenshot of how my query design looks like.

Am trying to write a macro to calculate some values, but for some reason am gettin an Automation Object Error (screenshots attached). I even tried to make a 'RemainingDeposit' field, in my table, and I still get the same error. Any ideas? Need help ASAP. Thanks in advance

Ok.. so ive writted this code to put a value in a text box in a form, but it only seems to work only if i use the On Click declaration, and it updates ALL fields with the same value. Dim amount Dim difference difference = Date - [txtDateLoaned] If difference > 2 Then amount = difference * 2...

Is there a way to make the selection of a query criteria a dropdown list?

Ok.. so ive been trying to convert a string to currency, but it seems its not working. Ive tried alot of workarounds, but still cant get it to work. Dim tday As Date Dim duedate1 As Date Dim amount Dim cur As Currency Dim difference tday = Date duedate1 = [txtDueDate] difference = Date -...

Am trying to add (2) to the date found in the field Date Loaned, but it isnt quite working Private Sub DueDate_BeforeUpdate(Cancel As Integer) Test = "[Date Loaned]" Set [DueDate] = DateAdd("d", 2, Test) End Sub Ive tried different alternatvies such as [Loans]![Date Loaned], ive tried alot...