Search results

OK I think I have the random bit working but I cant seem to use it to update a field??? any ideas?? Private Sub Check127_Click() Dim randpass As Integer Randomize randpass = Int((999999 * Rnd) + 100000) DoCmd.RunSQL SQLText, "UPDATE JobDetails SET JobDetails.password = randpass;" End Sub

hmm I have been playing with but cant seem to get it to work. Anyone know whats wrong with this code? Randomize Forms![CyclicJobInput].Password = Int((999999 * Rnd) + 100000)

I need to generate a random password. Is there anything in VBA I could use? Thanks

you can always turn warnings off in VB so the user is not prompted when sending your email. docmd.setwarnings warningsoff yourcodehere docmd.setwarnings warningson

if you click on the top left corner of a label you will be able to change the size of just the label. By click the top left corner you are selecting just the label and the relationship to teh text box is ignored.

No, the record can be updated if the user goes straight in and edits the main tab it is only when the user goes to a subform then back to the main tab. The links are correct as the subforms are all showing the correct information for the main tab.

I had this same problem, in my case it was not the code that was wrong but when it was being called. Make sure you requery the subform onenter that way assuming the append happends from a control outside the subform when the user enters the subform it is requeried.

You could disable all the other fields until a number is entered in one of you number fields, then use the AfterUpdate and enable all the other fields.

I have some forms that have a number of tabs with subforms. This all works fine. The only problem is when a user enters data on one or more subforms which are on a differant tab, the fields on the main tab which are not a subform change their behavior. They are not disabled as you can still...

I do this quite crudely. Onstartup the database runs a batchfile that outpust the users IP address to a linked table. I know what everyones IP address is so i can link names and time to the user.

pdx_man that perfect I really should have got that on my own! Thank you!

Could you not just query the table with the 2 dates and haev a critera under the depart date is null?

You takling spatial query their. Unless each customer has an attribute saying how far away they are from a postcode. I would say it cant be done in Access, you would need a GIS like ArcGIS or MapInfo. Or Oracle Spatial.

Is there any way to time how long a query takes to run. Without using a stop watch and watching the thing ;).

Sorted it! It was because the IP address in the form is a sting so need to change it: If DCount("[IPAddress]", "UserInfo", "[IPAddress] = " & Chr(39) & Forms![dir2].field15 & Chr(39)) = 0 Then

OK i know what you mean about field names I will change these when I get them working. I am still getting a missing opperator in expression error. Looking at your code above you have an odd number of " is this deliberate as that causes me errors also. Thanks Bob this is really causing me...

Thanks Bob that looks like exactly what I need. But what is "[YourOtherFieldName]". I have one value in a text box on a form and I want to know if taht is in a column of a table. So i have this but getting errors still: If DCount("[IPaddress]", "UserInfo", "&Forms!dir2.field15") > 0 Then...

Hi, bit new to VBA but learning quickly, I need to know if a value already exists in a table if it doesnt I want to send an email. Something like this: If forms![myform].value in table![mytable]column then docmd.runmacro "sendemail" I dont know what command to use for the in bit. Hope you...