Forms

Temporarily change a date field
Afternoon All, I have a time/date field [EventStart] with the format (dd/mm/yyyy hh:mm:ss) that feeds into a Flexgrid, but to make it match up with the way schedule staff and work load, I need to temporarily amend the date so it slots into the right part of the grid. My Flexgrid runs for a 24hour period fro... 26 Jun 2008 13:36

Is there a better way to code this?
Hi is there a better way of doing this I would have to add about 30 more Me.Combo131 = "" to complete this task? I have tried using the wildcard Me.Combo131 = "AC(*)" in various ways but none of them work. If Me.Combo131 = "AC10" Or Me.Combo131 = "AC20" Or Me.Combo131 = "AC30" Or Me.Combo131 = "BA10" Or Me.Co... 26 Jun 2008 12:34

Default Value based on database value
Hi there! I have a form displaying information about tenants. Sometimes tenants move out when they have already paid the rent, so I want to calculate what refund they are owed. On the main form it displays [Moved Out], I am trying to set the Default Value of another unbound text box to [Moved Out], I can then ... 26 Jun 2008 12:34

making field invisible in datasheet view
Heya all I can (suck eggs) make a field invisible in form view, but when I look in datasheet view, it appears as if nothing is happening to stop it... How can I make it disappear ? I need to do it so it doesn't appear in subform-datasheet context. Thanks in anticipation Pete ... 26 Jun 2008 10:29

Need help with this code to set the List Row Source.. . It works now !!
Alex; Thanks for Following up. I got it working. I fell into the spell of looking at code for a long time where I wasn't seeing our errors. The varaible we were using was ProductName.. LOL.. not ProductId. The first combo box independently looks for that . That took care of it and I had to use [ProductName] ... 26 Jun 2008 07:24

Form search
My problem is that I have creates a few forms. I have them set to search for information and then display on the subform that is on the main form. Well it seems to work fine in some of the forms, but then not in some others. I have checked the property sheet on the working ones and the nonworking ones and I see... 26 Jun 2008 14:38

How to code this math
Access 2003 =ACOS(SIN([Lat1])*SIN([Lat2])+COS([Lat1])*COS([Lat2])*COS([Lon2]-[Lon1]))*6371 Where Lat1, Lon1, Lat2, Lon2 are values in a table (So they will be fields) Is this math that Access can do? Is it as simple as dropping the formula in the control source? Any pointers here would be much apprecia... 26 Jun 2008 06:23

VBA not producing decimals
I have a form procedure in which I'm doing very simple math and would like a calculation to produce a decimal to two places, but I'm not sure how to do this in VBA. My code: Dim intTmMin1 As Integer Dim intTmMin2 As Integer Dim intTmHr As Integer Dim intRateTot As Double Dim strMsg As St... 25 Jun 2008 20:10

Suggestions Please - Subform Results Export to Excel
I have a Mainform where the user selection from one or a multiple of 4 comboboxes and select a date range. This information displays in a subform. I would like to use a Command Button on the Mainform to export the information displayed in the subform to Excel. Suggestions Please. Thanks -- tmdrake ... 13 Aug 2008 03:34

Creating Hyperlinks from Fields within a Table
Hi all – A quick new project I am trying to tackle and would appreciate any and all suggestions / comments :) I have a table, tbl_Journal_Entries_Listings_Divisional, that has these fields: Div, Mth & Yr, Journal No, and Scanned JE Link. These are the fields that I could use to create a hyperlink. For examp... 26 Jun 2008 09:27