Search results

I used this method to open another form showing more information on a record. On the tabular form choose the field which you want the user to 'click' on. Go into design mode select the field you have chosen. Select properties, then select the on click property. Use the code below, substituting...

Hi If you do a search on " Audit trail" The thread answered by Ghudson will probably help. HTH Norman

Hi Some time ago I used a login system to check user passwords (or pin numbers) these were actually stored in a table but I am sure that the following could be adapted to suit your scenario. This is used on the onclick event of your command buttons. It needs an additional field...

Hi Mike You could pass a parameter from the calling procedure ProcA() … Call ProcC(1) … End ProcB() … Call ProcC(2) … End ProcC(Callerid as integer) Select case Callerid Case 1 Msgbox " ProcA called" Case 2 Msgbox "ProcB called" End select End HTH Norman

Mresann Thanks for that, as I said I'm no mathematician. So, what I should have said was If the Mod operator is 2, then if the number(integer?) being tested is even, then 0 would be returned. If the number is odd then 1 would be returned . My example worked only because I chose to use 0 in...

Glad to hear it worked. I'm not a mathematician so I can't explain fully the workings of the Mod function. In simple terms what it is doing here is, [customerid] mod 2 takes the customer id number for a record and divides it by 2 the mod function takes the remainder from the number...

Hi If you have a unique id number in the table, you could try this Add a new field to the table say packtype then using an update query with Field packtype table tblcustomer update to IIf([customerid] Mod 2=0,"r","b") This won't guarantee 100% 50 - 50 split if...

Hi You can change the start value from 0 to 1, this will give you the ranges you want. Values for zero will be in it's own range. Access help gives the example below (with 0 as the start) SELECT DISTINCTROW Partition([freight],1, 500, 100) AS Range, Count(Orders.Freight) AS Count FROM Orders...

My virus scanner reports The file C:WindowsTemporary Internet Files\Content.IE5\KX8FGNEP\XXX-MOVIE[1].SCR was infected by the BackDoor-AVW trojan and has been deleted This has been attached to other topics Norman

Hi I haven't seen any for the words, but this word document is good for the numbers! I keep saying I will look at the code and try it in an Access module but I've not got round to it. Has anyone else? Norman

This link has example code to parse comma delimited text. You will need to play around with it to import. http://www.mvps.org/access/strings/str0003.htm HTH Norman

This was discussed not long ago on this thread http://www.access-programmers.co.uk/forums/showthread.php?t=62751 The concensus of opinion was that it was not easily possible Quote from Pat Hartman "If you can have your import changed to fixed width you'll be able to automate the import by...

Yes it is Norman

Open the form in design view, from the menu select field list.. Highlight the field you want on your form and drag it to where you want it. Alternatively you can select the type of object from the toolbox, ie text box, combo, drag it on to the form. Left click on the object, click on the data...

You don't need any code to do this, make the field autonumber and follow the instructions in Access help - autonumber. Change the starting value of an incrementing AutoNumber field For a new table that contains no records, you can change the starting value of an AutoNumber field that has its...

Mat Sorry to confuse, I haven't got an answer to your problem, I was interseted to know how you had managed it for Fixed width fields as it wouldn't let me do that either. Norman

Mat I have tried creating a table with greater than 255 fields and it wouldn't let me. (I created a table with one field and used the Alter table method to add fields) I have also tried importing data using the import method and where the number of fields was greater than 255 it put all the...

I found this on Microsoft Knowledeg Base Article 154070 The Microsoft Jet database engine has an internal limit of 255 fields per query. As the Microsoft Jet database engine iterates through the records in an update query, it creates a field for the original value and a field for the updated...

Hi Rhonda I think that these are causing your problem, I don't think they are needed, the Sheet information and project number shouldn't be needed in the Answers table. I have to go now, but I will look more closely in the morning, if you like. Norman

Hi Rhonda I have another query (tblqryUser) that brings in the project number and two more append queries (qryGenerateQA, qryGenerateQC) that bring in the sheets. Can you post the syntax for these queries, if they are append queries as you say, they will only add rows to the table and not...