Search results

Does anybody know if there are books for learning visual basic for access 97/2000

Ihave been lookoing at Northwind, but I still can not work out how the subform is linked to the order No. The Order No is autonumber, and all the records in the subform for one order come under that Order No. Can anybody exolain how this works

No, the form is basically the calendar control

I created a table to store the username. I created a module Option Compare Database Option Explicit Public strUserName As String Could a reference strUsername to the table, how would I do this?

Is me.name the name of the form? If so I tried the code and it still put the calendar form behind the form that is open

How could I call up the info so I could use it in other forms and reports. I thought I would need a Global variable. but I don't know how to do this or how to call the variable up.

On my form I have a button which opens a calendar, when the user clicks on a date it puts the date into a text box and close. If the user clciks on the button by accident,I want the user to be able to click anywhere on the form instead and the form will close. I tried OnLostFocus, but it puts...

I am new to the module thing, but I think this is what I need. I want a button on my switchboard where the user can enter there user name and details. Each database would be for each salesperson for there laptop. I want the database to save this info, then be able to call it up for putting there...

I found this code in the forum Dim intCount intCount = DCount("FieldName", "Table/QueryName") If intCount > 0 Then MsgBox "There are " & intCount & " records that expire in 30 days.", vbInformation, "Tax or Mot Expire Warning" End If Can you get a form to open before it runs this code. The...

iI have had a look at Northwind, I am not quite sure how it is do. It brings up the subform as a new record, but how to assigns CustomerID with OrderID a bit lost. I did want to do what Pat said add a Yes/no field, but my subform is in datasheet view so where would I put this field? My subform...

How would that work? I am not sure where I would put the yes/no orders complete. It would need to be attached to the subform, the subform saves the orders into a orders table.

I need some ideas. On my main form I have clients details. There is also a subform that you can select as a product and qty, these to forms are links and all works fine. I can produce an invoice But if the client a week later wants to buy some more products, I can select them from a listbox...

I have posted a simular question before but did not explain propely. I have a combo box on the main form, and one on a subform. By selecting a category in the main form combo, when I select the combo on the subform I want to show only the ideas in that category. The subform combo box has a...

I have tried that code but I want to be able to select a record from a listbox then click delete, how do I put in the code the record I have selected from the listbox

I have a list box which lists all my records I want to be able to select a record from the listbox and press a button to delete that record. I used to wizard to create a delete code, but I don't where in the code to tell it to look at the list to see what record needs deleting. I also want it to...

I have a main form with a subform on it. The main form has customer's details on it the subform has products. When you select the combo box product on the sub form you select the produce and the price is filled in. I want to put a combo box on the main form with categories on it, so you can...

Thanks alot

I have a main form with a subform on it, is there any way to change the size of the subform i.e make the headings and data a smaller font

Thanks for your help I worked it out before I had chance to let you know

Yes, thanks for that. I have another question if you don't mind Now I have my sub form working I want to put on the main form a text box that shows the total for the products sold to the client. I have done this with a query attached to a list box, but can not get the subform to refresh the main...