Search results

I want it to take the the values from the fields that have associated tick boxes set to true onto a new record. I got the sample database which I previously had got working from this thread. Please see for more info: http://www.access-programmers.co.uk/forums/showthread.php?t=185144&page=2...

Thanks for the comments. I got the code from a sample database that had a similar function so Im not too sure what it should be! :( Yes, that is the line that comes up highlighted when I click debug. Any ideas on what I could try? Thanks again

anybody got any suggestions???

Hi guys With some help i had previously been able to make a button on my form that copied that record to a new record (depending on which check boxes were ticked). It all worked ok but after some more work on the database im getting a runtime error 438 when trying to run the command button. I...

perfect! Thanks Paul! Unfortunately the company have all their current paper datatbases and stocks set out in this format so im having a hard time convincing them to change it to solid numbers. It works for the time being... Thanks again

I have attached a scaled down version of my DB. Any thoughts? Thanks

Its working if i amend adams version but not on mine! THe only thin i changed is the table name, and the index ID...

Thanks, but still not working. Now the command button opens a blank form.. My code is Private Sub cmdFill_Click() On Error Resume Next Dim strSQL As String strSQL = "SELECT * FROM tblTicketing WHERE StockNumber = " & Me.StockNumber DoCmd.GoToRecord acDataForm, Me.Name, acNewRec Dim c As...

Ye, i assumed that also - checked the table but all have values in! Really dont understand why it wont work. Any more ideas?

Its input by the user (not an autonumber). Typical value might be N11611/4

I have tried them... 1 way gave the same values for ALL new entries, not just the next one. I couldnt get the other one to work (carry current before insert) I have no idea about SQL statements etc. Is there somewhere that explains how to do what you are talking about? The third method...

When i try to use my previous code i get an error saying it would create duplicate index (runtime error 3022). How can i fix it?

With my orig code I get an error 3022 (would create a duplicate index?). Anyone know how I can fix this?

Its not working :(. Not sure why

ah, yeh just noticed it - only had one record in the table previously! Does anyone know how to rectify this or another method?

So my calculation need to go in the query? Where and how do i insert it?

So my calculation need to go in the query? Where and how do i insert it?

Hi I have a report with a few hidden textboxes because they are controls for a long calculation. However in the report every record shows the same calculation when it shouldnt... Im trying to create a report for multiple records. My calculated textbox is...

perfect! exactly what i was after... thanks

perfect! THANKS