Search results

Well here's a weird one! I have lots of reports in my database which all work fine no problem at all. I have a custom tool bar for the reports and one of those runs a macro which displays the page setup dialog box. I've been working on a report which when previewed displays correctly on the...

I'm not sure if you can show a subform from within a form if the defaul view is DataSheet. However what I have done is to have 2 subforms on a main form. The main form links to subform1 and subform1 links to subform2 In order to link a child subform to a parent subform, in the 'Master Link...

Hi Andi It is entirely possible that my users did get a warning and chose to igore it. If an system warning message did appear then they would normally contact me for more information. However I've tried to cover all eventualties where Access default messages are concerned. Also all of the...

Hit there, Below are some of the code that I use to test permission rights. Basically what I've done is declared public variables in a module and in they contain the login details. Private Sub cmdOK_Click() ' Check to see if password is entered If IsNull(txtPassword) = True Then...

Hi there, I've had a similar problem too! Basically a few months ago, users were starting to complain that the database was extremely slow and I couldn't figure out why. It was only by chance that I discovered that a relationship was missing / deleted and it happened to be between the 2 main...

Hi there, You need to use the SendObject action. Here is an example of the code I'm using: Private Sub cmdEmail_Click() Dim strAddress As String Dim strDocName As String strMessage = "You are about e-mail Order Number " & Me.OrderID & Me.Initials strMessage = strMessage &...

Sambo Well it's Monday morning and I tried your code and guess what....it works a treat!!! Many thanks and merry christmas Rob :D

Hi guys I have a bit of a problem which I hope someone can help me out with. I have a main form (frmGoodsReceived) and a subform (frmGoodsReceivedDetailsSubform) both linked on OrderID. Basically this form allows the user to select an order, load the details of that order into the subform and...

Hi Redwood Is there any chance you can e-mail me a sample of your db so I can have a look at the report for you? I believe the answer does lie in how the data is grouped but it would be better if could have a look if possible

Hi there, I've just designed a report where I've had to mess around with the groupings to get the desired results...a right pain!!! In your case I think what you need to do is to set the groupings in the following order 1. Sequence # Sort ascending No group header / footer 2 Part Num. Yes to...

Hi there, I'm afraid your post is a little vague so I'll try to help as best I can. Firstly you say that you are trying to create relationships. You have to create relationships between your tables in the 'Relationships' window. All the tables you have created should show. Secondly if you are...

If you've split your database and all your users have a copy of the front end on their machines have you tried importing all the front end objects into a blank database and do a 'Compact & Repair' on the front end tables? Try this and see if it helps.

Can you be more specific. What DoCmd statements are you doing and what error messages do you get?

You could make use of the controls collection and then make use of a For...Next loop to test each control to see if it has an entry. The code would look something like this: Dim ctl as Control For Each ctl In Me.Controls If ctl.ControlType = acTextBox Then If IsNull(ctl) Then MsgBox("Your...

Or you could try: Forms!FormName!subFormName.Form!txtName.Enabled = False

Hi arage I have had a similar problem when referencing controls. Basically what I was trying to do was to create an undo routine and restore the old values by using the code: ctl.Value = ctl.OldValue. The problem I had was trying to reference each control type i.e acTextBox, acComboBox etc. The...

Try this For Each ctl In Me.Controls ctl.Locked = True ctl.Enabled = False Next ctl

Hi Mitch Glad you sorted it. You were right to place the code in OnActivate event. Basically the order in which the code is executed is: Load Event ---> Activate Event.

Try this: Private Sub Report_Open(Cancel As Integer) Select Case text64.Value Case "M. Wilson" Me!Image63.Visible = True End Select End Sub HTH Rob

Hi What you need to do is to create a function that returns the value of your global variable... Public Function GetVar() as String or whatever GetVar = yourGlobalVariable End Function Then in your query set the criteria in field you want to filter on to: =GetVar() HTH Rob