Search results

Hi all, the code below is used for a log for changes, problem is it logs blank fields, could you please help me with the extra code so it ignores blank fields. BTW I didn't write the code....too much of a novice;) Function LogChanges(lngID As Long, Optional strField As String = "") Dim...

Hi all, could you please help me with a bit of code. what I would like to happen is when I click on QuoteNeeded (which is a yes/no) it will put active in CusomerActive also once I have clicked QuoteNeeded it then becomes locked just in case you need these, the form name is CustomerF...

I found out why only record 1 was showing. I must of deleted the where condition in openform it should have been [CustomerID]=[Forms]![MainR]![CustomerRDS]![CustomerID] thanks for helping peter

form CustomerRDS is where I set up the on click event for CustomerID to open up form CustomerR mainR is the main form I want to use which is a navigation form what I need is when in mainR if I click on any CustomerID I brings up that record to view/edit peter

I hope that works peter

Hi John, thanks for the reply, lol, it works, but now when I click on CustomerID to open up the record I what to edit it now only opens CustomerID record 1 let me know if you need more info peter

well, it is working, but it also works if I change nothing :confused: peter

Hi pr2-eugin, thanks for the reply, that works, thanks for explaining, I'm new to this and that helps :) peter

Hi John, ok, I've found out how I can get last updated to work, but it only works for one field at a time, if I have to change two field then I would have to repeat when the form opens on the left hand side is a bar with a pencil in it at the top, if I click that bar it turns black and a...

Hi alan and john, thanks for your replies...... john I tried what you put and last viewed works fine but last updated does not show up I even tried after update and on data change in form events and still no date showing in last updated any ideas!! thanks peter

Hi all, how can I get dates to show in last updated and last viewed fields I've tried to do it, I did get last updated working but for some reason when I tried to do last viewed, last updated vanished :/ I did try writing code (but im a novice lol, I think that's why last updated vanished)...

Hi John big booty, Thanks for you reply, I tried your way but I got an error I managed to get it working, by going to the table in design mode then create data macro then before change then set field, I then put my field name (company) in name and StrConv([Company],3) in value thank you...

Hi jdraw, thanks for the reply, problem is I forgot to mention that I'm a novice, so I have no idea how to get that working any help would be appreciated peter

Hi all, is there any way of making data that is inputted in lower case to automatically change to the first letter of each word being a capital :confused: please can you let me know how if it can be done thank you peter

Hi, I am hoping someone has changed and added a extra database to the northwinds template for customers equipment and is willing to share it with me :) I am a complete novice at this and the northwinds template is something that I would like to use, but I don't know where to start to add a...