Search results

You refer to the tab by using it's name as follows: me!TabName.visible = true Just use this in the VBA window on the required event and obviously change 'TabName' to the actual name of your tab.

You could open a recordset as the report opens that checks for a supervisor with a count of 5. Something like this: Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("SELECT .* FROM [TableName] WHERE CountNo = 5", dbOpenDynaset) If rs.RecordCount <> 0 Then rs.MoveFirst Msgbox "Supervisor...

Try puttin 'Me!' in front of each controlname as below: Private Sub save_Click() CurrentDb.Execute "Insert into Full_Details(Col1,col2,col3,col4,col5) Values ('" & Me!Combo0 & "','" & Me!Combo1 & "','" & Me!Combo2 & "','" & Me!Combo3 & "','" & Me!Combo4 & "');" MsgBox "Record Saved !!!"...

If txtCUSTOMERNUMBER is a string then you need extra quotes so try this: UPDATE TblClients SET TblClients.Audit_to = #" & Format(Me!MaxPostingDate, "mm/dd/yyyy") & "# WHERE TblClients.CUSTOMERNUMBER = '" & Me!txtCUSTOMERNUMBER & "'"

You could bypass the report and printing functions by exporting the report to pdf. Not really a fix but it may get round your problem until someone comes up with something better or Microsoft creates a patch.

Have you tried sending the report straight to print without a preview?

I have seen this problem crop up a few times and believe it's a bug in Access 2010. Take a look at this for a possible fix: http://www.access-programmers.co.uk/forums/showthread.php?t=223383

It depends how big and complicated the database is. If you were talking about one table then running code to merge them both wouldn't be so bad but if you're talking about many tables with many relationships then I don't think it can be done. At least not without some major coding/headaches! I...

Hi, You should use an autonumber as that's what you need. To start the autonumber from a set number like 8000 you can run an append query to add a record with the required number to the autonumber field.

Have you tried just opening the web page first with something like the following: Dim ie As Object Set ie = CreateObject("InternetExplorer.application") ie.Visible = True ie.Navigate "www....." Do Until ie.ReadyState = 4 Loop 'Your code for donwloading the .csv here

Are the buttons on the single record subform? If so then the recordcount is being returned from there so you need to tell it to target the other subform like so: If Me.Parent!SubformName.Form.CurrentRecord < Me.Parent!SubformName.Form.Recordset.RecordCount Then DoCmd.GoToRecord , , acNext...

You could have 2 seperate fields - one that is formatted to show just time and where you would enter the time and the other to be formatted with date/time and is populated after the first one.

I believe you would have to pay to use Sharepoint as well and it's probably no cheaper than remote hosting so free 'log in' software is probably the way forward.

Add a new column to the query and in the field put this: AutoQty:1

You would have to either remotely host the database and then you would both log in to the remote host to view the database. Or to log on to your dads network/pc you would have to remotely log in to the computer/network via a remote desktop connection or software such as team viewer or logmein.

What line causes the error?

>= DateAdd ("h", -6, DateA) < DateAdd ("h", 18, DateB)

Yes as follows: For the first one it would be <= DateAdd ("h", -6, DateA) For the second it would be < DateAdd ("h", 18, DateB) NB: DateA and DateB would need to be replaced with your inputted dates. One other thing for the first one ddid you meqan this is UP TO or should it be FROM. If...

There is an option (Tools/Options Form tab I think) to use 'Windows-Themed Controls on forms'. It sounds like this maybe ticked on one of your setups and not ticked on the other - or it may be that it is ticked on both but the Windows theme is different.

It's because you're trying to link an Autonumber to another Autonumber and this is not allowed. Change the child table from an Autonumber to a Number (long Integer) and then the link will work.