Search results

I've Created A Module Called "Globals" I've put the following code in the module Option Compare Database Public Function Init_Globals() GBl_student_ID = 0 End Function Public Function Get_Global() Get_Global = GBl_student_ID End Function On the Close Event of my login form I have the...

In my Db a user belongs to a company, a company can belong to various PrimaryDataTypes. TblPrimaryData TblPrimaryDataTypes TblLinkPrimaryData2Types The last one is basically a many to many relationship link table which stores the PrimaryDataID along with the associated Type On my splashscreen...

I'm trying to warn a user if no check boxes have been selected but this code doesnt seem to work. Am I wring somewhere? If Me.chkCommercial = "0" And Me.chkDomestic = "0" And Me.chkHotSpot = "0" And Me.chkReseller = "0" And Me.chkVoip = "0" Then MsgBox "You need to define enquiry interests"...

Thanks all, I found setting the focus solved the problem.

Here is a snippet of some code on a form. User in the main form (frmPrimaryData) that form contains among other things clients name and address a user who wants to change or update it clicks a button which opens up an unbound form, clicking save triggers a SQL UPDATE... Once thats done I want...

the solution was to remove the = this one works objmessage.AddAttachment ("file://c:\test.txt")

Also, email sends fine until I try to add the line with an attachment?

I think thats already done with the line Set objmessage = CreateObject("CDO.Message")

No, not sure where to add that?/code

It's the following line: objmessage.AddAttachment = ("C:\test.txt")

I'm trying to modify the following code to allow attachements but keeps erroring "object doesnt support this propery or method" when I can see thatothers are using the same? Private Sub cmdEmailProductSpecs_Click() Const cdoSendUsingPickup = 1 'Send message using the local SMTP service pickup...

did you get a template? I'd like one too.

Many thanks for your reply and information. As a newbie am just beginning to understand what recordsets are for!

I am using some code to retrieve a value to become the value of a text box. Am i right in thinking that when using DLookup NULL values have to be handled whereas by using a SELECT statement I dont have to worry about NULL throwing up an error? If so, having constructed the following code, how...

I'm using the following code I've found to try and populate a combo box with a list of users from Active directory. I get a runtime error "Table Does Not Exist" and fails at the following line: Set objRecordset = objCommand.Execute Any advice most welcome :o Private Sub Form_Current() Set...

Thanks for your reply and off the back of that I have constructed the following. So where there may be a customer id number 105 and twenty entries for that customer id the following picks the latest entry of that customer id. SELECT DISTINCT Last(radacct.RadAcctId) AS LastOfRadAcctId...

I'm working on my Db; when a customer record form is opened the system checks the status of their IP Address. But some will not have an IP address listed. So I'm trying to code in that if the IP address field is bank then to exit the routine but i seem to be getting stick and have an error...

I'm building a database which needs to lookup a value from another database. The other database records users logging in and out and records their mac address. What's the best way for me to tell access to look for a particular mac address but the last one as distinct from all the others? Any...

I'd like to be able to populate a table (TblUsers) with members of an Active Directory Group (DbUsers) and based on that then be able to write various bit of functionality. The Active Directory bit is the aspect which I'm new to and could do with some principle advice or points to any links...

Many thanks for the reply. Based on your advice I have found that actually its really not that hard. Thanks.