Search results

hi I would like to add some cells in access together (I know it would be far simpler to use Excel, but I'm creating an Access database and just need to add up a couple of cells to create a running total). Is there a way of doing this using Queries? thanks

Hi i currently have a simple spreadsheet in Excel containgin the following fields. ## Date - not unique simpy shows the date of the transaction ## Debt - who the debt will be paid to - unique per date (e.g. CompanyA) ## Type of debt - what service is it - not unique by date or debtor (e.g...

hi can anyone help me with some code please. I would like to open a URL just by clicking a button within a FORM in MS ACCESS. thanks in advance for your help mike

i have a 2 forms. on1 there are numerous buttons and a text box to enter a name. on the other form there is a caption, which will show the name that was entered on the other form. (it is not a text box because then it may be edited) is there code that can be entered either behind the text box...

i havent used VB for a while, so im a bit rusty, but i was lookin at my old work and for some unknow reason i keep gettin an error when i use almost identical code for work im doing now. what i want to do is close one form, and open another by pressing one button. b4 i was using Microsft Access...

hi every1, i have a form which data is entered into, but i need a button to refresh the fields to be blank again. i tried some code which closed the curren form then opened the same one again, but i got errors. any1 have the code the refresh the form? im all out of ideas!

hi every1, im having some trouble creating the functions of a form in VB. heres what i need to Do.... create a login form and if the incorect password is enterd 3 times, a pop up appears saying that u must contact the administrator. i need some sort of loop i think! can some one help me...

hi every1 in a table i have 2 values in the 2 fields Weight and Levy. in a query then i create a "Total" field by using the formula below. Total: [WEIGHT]*[LEVY] unfortunatly the output of the number is in pence, eg 100 instead of 1. is there anyway i can format the way the data is displayed...

hi every1, can sum one tell me is it possible to have the data in one field to be determined by the values of 2 other fields. i need one field to show a Value, of 2 other fields Multiplied (X) together. for example the value in field A is 2, the value in field B is 3, therefor the value in...

hi every1, heres my problem... im creating a simple DataBase, to begin with there is a Parcel table and a Shipment Table. the key fields are Shimpent Id, and Parcel ID, which are both autonumbers. in the Parcel Table there is also a ShipmentID field. there will be a One to many relationship...

I have a form to enter information on films. on the form there are 2 tabs, which i use to seperate the form in 2. But when i open the form the tabs aren't shown so i have to scroll down to see them and use them. why does this happen??? can any one help???

I would like to create a look up menu to search through a customer form, to automaticly see their information, but I am unable to do this! Can anyone help????

I would like a form, with a button, which, when pressed, would go directly to another form, the "Customer Form" with blank spaces ready for the entering of data. I am finding it hard to do this and have no experience of using Visual Basic. Can anyone help?

I want to create a sub form but, one in a datasheet view, the other in a columnar view. im having trouble doing this. my sub forms don't work, please help!!

For my A-Level project I have been asked to complete a database using Microsoft Access. I have decided to base my project on a film mail order company. I have been having trouble completing an Order Form. In this Form, there are 3 Tables involved. The "Customer Table", which includes information...

For my A-Level project I have been asked to complete a database using Microsoft Access. I have decided to base my project on a film mail order company. I have been having trouble completing an Order Form. In this Form, there are 3 Tables involved. The "Customer Table", which includes information...