Search results

HI I am just wondering if any one knows why if I have a list of numbers e.g. 1,2,11 and I do sort assending does it put them in the order of 1,11,2 rather than 1,2,11 Does anyone know how to correct this?

Hi I have a data entry form to enter a new record. the forms is set to data entry and pop up. My problem is that it wont let me add a close button either through wizard or manualy it just come up with: object or class does not support teh set of events. How can I get it so that when I click a...

Hi Thank you for that but could you just simplify that code a little (just explaine the syntax parts i.e what is it?) The table is 3 sqn The field is user Let me know if there is anything else you need

Hi Yes that is all correct. Sorry its taken some time

Another option is instead of asking if the user carried out the check to just ask the user to enter a name. Would this make things easier and if so how could I do it?

Hi When a user carries out a check of the stock they can click a command button which changes the date the last check was done. I have now added a field called "user", this is populated by, when the user clicks the button it asks if he carried out the check (there is no guarentee that he did so...

Thanks for replying. Yes this function is relevent as it acts as a trail if anything goes wrong which my bosses want. My problem is that the user will carry out a physical 100% check of inventory items then click the button to say it has been completed and that he DB is correct. I have a field...

Hi I have a command button on my form which when clicked changes a date in a field of evey record in a table. I have updated the code so that an extra msgbox comes up asking if it was the current user who did teh work. If the user clicks yes a field changes to their login if they click no then...

Hi All that I have done is made the field required that way they have to input a number so hopefully they will use their common sense Thanks for following up

Yes it is bound

Hi i have a list box on my DB. Is there any way I can have a button so that when clicked a txt box comes up where the user can enter a new value into the field? Thanks

Hi thanks for replying. The code that I have already on the after update event is: If Me.QTY1 > 0 Then ON_DEMAND = True End If If Me.QTY1 < 1 And QTY2 < 1 Then ON_DEMAND = False End If This works fine unless there is no number in the box.

Hi I have a number field which controls a yes/no box (basically if the number is greater than 0 the box is ticked). However I have just discovered a problem, if the user just deletes the number rather than putting a 0 in teh box it wont change my yes/no field to no. How can I have it so that...

Thanks for the reply. yeah that works great

HI Everyone i have a field in my table (min qty) which needs to be filled in once when entering a new record but I dont want to show it on the form all the time. How can I have it so that when the ref number is blank the field is visible and once information has been entered it is invisible? I...

Hi Thanks I will have a think and let you know Thanks for all your help

Thanks that works great, just one more thing is there any way that I can not have the warning that comes up saying do you want to allow this? Just as I dont want anyone to click no.

Hi Thanks for that. Yeah I had thought of the problem about only the first time its open on a friday. I have never used the DLookup before is there any chance you could fill in the blanks i.e. DLookup(etc etc) and "Update etc etc" The table with the if run field is 29 Sqn and the field is "run"...

HI Thanks for replying. Yes I have a form which opens when the DB is opened which acts as a menu for all the other forms. How would I go about doing it so that the macro runs on a friday only? Thanks

Hi I have a macro to send a query to an email address. Is there any way I can have this execute every Friday? Thanks