Recent content by MikeUK

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

in the Payment table of course there will be the cost, cost before Vat, etc...

thanks for your replies I'm not really concerned with the VAT aspect of the data input, as it's usually written on the invoices that get input into the spreadsheet (and in future into the DB). I've figured out my soft entity, a Payment Table with PaymentID, Date, DebtorID and DebtTypeID...

I'm trying to start with an ERD, and trying to eliminate the Many-to-Many relationships. I can see 3 tables, a Debtor tabel, a Type of Debt table, and a Balance table containing the figures. I can't see what soft entities I need etc to make this work???

hi thanks for your reply I was thinking of just using Access, and scraping the Excel all together. this is because when I did try the import, i needed to store the data in a table, adn therefore I will then have to copies of the data. I was thinking of going down the route of using everything...

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...

hmmm that was simple wasnt it! Cheers!

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

ah, i think i should have told u about the fact im not using access, just VB!! i just need a button which when pressed clears all the data entered onto the form, i dont think the data is stored anywhere, im just creating a HCI. if i was using access i could just use a button wizard beacause...

rite i tried ure code, but im not sure if ive done it right, it doesnt work so i assume that ive got it wrong. Private Sub Label3_Click() Me.Label3.Caption = Forms!Form3!Text1 End Sub "label 3" is the caption i want the data to be displayed in "Form3" is where the name was typed it was...

sorry not quite sure what ure trying to say there mate :S

thanx ill give it a go later today and get tell you in here if it works! :D

thanx, ill try that tomorow when i have a chance, ill post back here if i have any trouble. thanx

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...