Search results

Thanks UncleGizmo As you suggested I inserted an extra column and used this formula '=TEXT(D376,"dd/mm/yyyy")' to copy the dates into the new column. Imported the data into Access as a text and then converted back to a Short Date, which works fine. (How come pre 1900 dates are OK in Access...

Thanks UncleGizmo That worked for importing the pre 1900 dates but the post 1900 dates were imported as a number, i.e. 14167, 8874, 14153, etc. (I assume this is the date serial number).

Hi all I am trying to import data from Excel into Access to create new tables. However in some of the excel spreadsheets I am importing there are dates which precede 1900 and, although the data type is set to short date, for some reason excel decides to store these as text, so when I import...

Start by using the form wizard to design a new form but only put on the key data fields, i.e. name address etc. Modify the form design and add the tab control to the form, click on the add existing fields button on the top menu and then add the fields, as required, on each separate tab.

Not sure what you are asking here. If you are just looking to group controls into groups on the form you could simply draw a rectangle around them and set your tab order to move from one control to the next in order. Alternatively you could use a tab control and place your controls on...

A tab control is just a way of sgregating your data fields into more easily managed sections. For example your main form may have basic demographic information, i.e. Name, gender, address etc. then you can have separate tabs on your tab control for data such as Business information, Leisure...

So it sounds like you have too many fields to fit within the limit of 22in (55.87cm) To insert a Tab control, in design mode click the Tab control button from the menu at the top of the screen and click on the form where you want it to go. You can then drag the control to get the size you...

I have not come across a limit myself in the number of fields on a form and it may be, from what you are describing, that the limit is not the number of fields but the physical size of the form. That said, the more fields you have the greater the amount of code you will have running in the...

Try this Age = DateDiff("yyyy", [DOB], Date) - IIf(Month(Date) < Month([DOB]), 1, IIf(Month(Date) = Month([DOB]) And Day(Date) < Day([DOB]), 1, 0))

Setting up a report grouped by Portal will allow you to extract this data and get totals for each portal. Hope this Helps Dave

Hi Twinnie The issue here is that Macro's are no where near as functional as VBA code and, whilst it is possible to run SQL code in a Macro I am not sure that you can use a Macro to amend a form control attribute (i.e. Rowsource), as the VBA code does. Dave

They will either be declared in a separate module in the database or in the Compare and Declarations area athe top of you code. Look for something like: Public fGetUserName As String You can also add a watch on the variable and watch the stored value as you step through the program. If...

Try using the DLookup function. regards Dave

Have you referenced the variables fgetusername etc. as Public, otherwise they will only be populated inthe function / sub-routine that references them. Regards Dave

Looking at the sample file you attached you are linking to the ID field in your Level_Type table but usingthe text in the Staff_List table. Try adding the following code to the cboLevel after Update event. This will refresh the Staff_List control each time the cboLevel control is updated...

I found this code really useful when setting up BE/FE Database and copying FE to users personal drive. The function will create a shortcut to the FE software on the users desktop so the user doesn't have to search for it. The function takes 2 paramaters, strFileName = The name of the link...

Hi Paul Thanks for this. Tried it but am still getting the same error. What's odd is that the same code works in other forms in the database, it is just this one. I have checked for name conflicts and deleted the form and started again but still keep getting this error. Cheers Dave

Hi All I have a form which uses a list box to select which record to display. The code is all generated by Access during form design. It is a method I have used numerous times inthe past in various database without problem (even in the current database I am developing). But for some reason...

I think the .Text expression is only valid when the textbox has the focus. Try replacing Me.MobTextBox.Text = Me.MobDate.Text with Me.MobTextBox = Me.MobDate

Check the names of your text boxes against calculated values etc. You may have a conflict.