Search results

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"...

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...

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...

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...

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...

My system needs to connect to another database (MySQL) to periodically pull some data across and update some tables in my Db. I'm looking for some advice as to the best method to accomplish it programatically. Thanks.

My Db is split and uses the user level security with the built in Admin account disabled. -Split Db Front end / Back End -Back End Db is encoded -Access user/group level security being used I am just trying to get functions to work but they require an external link via a system or file DSN...

Hi all, I'm using this bit of code on my splash form to ensure that the Db can only be used on computers which I have authorised it for. 'Checks the computer being used is authorised to be able to use this database Dim sHostName As String sHostName = Environ$("computername") If...

Hi, i could do with a bit of help with the following: I have attached the database so that you can see what I am doing. In my main table I have a couple of fields which rely on being able to compute the values of another table linked by quoteID but am coming up against mental brick wall. any...

Have searched for answer but cant see. I have a form with three dropdown's, each assigned to their own query. On the form I have a 'Close & update' button. I want to create some code which, on button press, will take my selection and pace data into another table with corresponding field names...

New to Access! I am creating a quotation database where a new company name will be entered. In 1 form a pick list of products which I then want to go into another table associated to the company name which can then be queried and displayed in a report for printing the quotation. I have created...