Search results

Hi guys I use Access 2007 as a front end to Mysql and would like to be able to send an automatic email somehow to a customer when data changes. The DBase is setup with Username as the key field and every other table uses this, tables are Users Appointments Invoices Estimates Payments Pictures...

Hi Guys I am attempting to use MsAccess 2007 as a frontend to Mysql hosted by myself. Everything so far has worked correctly until I come to the upload picture part. I have this section working correctly with the website, I select the PDF file I want to upload and click submit and it is...

Hi guys Not posted for a long time and don't have permissions to post in Querys Faq. I want to be able to run a duplicate query on ProductID, it usually has 2 or 3 same ID's as somethings come through as special offer. I want to be able to run the query to search for the duplicates and...

Hi guys Got my table working ok now, but having a slight problem with this one. I did have a standard text box for "Employee" and have the user enter their name, now I have opted for a drop down menu instead, but when I select a user, Mysql returns blank ?> <h1>Employee Time Sheet</a> </h1>...

Hiya guys I have the following table in SQL Jobs - JobID - Date - Customer - Address - Description - Assigned To Employees - EmpID - Employee Name - Employee Address - Employee DOB - Employee NI TimeSheet - TimeID - EmpID - JobID - Date - ArriveTime - BreakStart - BreakEnd...

Hiya guys I'm using Access 2007 I have a basic table to play about with that I am trying to use with Mysql on my website, and I have no idea I have created a table on mysql called "employee" I have got the same table in Access, Can't find anything in access on how to connect to mysql

Hiya Guys I'm looking to build a basic table that spits out an ID that I can use in SAGE Accounts for my customer ID I want something like: First Name: Last Name: CustomerID: (First Letter from First Name)&(First Letter from Last Name)&(random Number) Sage only allows for 8 spaces so...

Hiya guys I'm adding a new table / form into my existing DBase and not sure how to arrange it The main table / form in the Dbase is Customers, ref by CustomerID and the whole Dbase uses this for its record links. The new area I want to add in is called "Annual Checks" The business I have is...

Hiya guys I'm trying to send some data to the Outlook 2007 calander, everything works perfectly apart from, access is telling it to repeat the added appointment every week. Here the code that I got my Microsoft site Private Sub Command23_Click() On Error GoTo Add_Err 'Save record first...

Hiya guys Access 2007 On my form I have 2 buttons, one creates the workorder by finding the last WorkorderID, the other button sends the field entrys from one form (Quotes) to (Workorders) In order for this to work the Create Workorder finds the last workorderID and tells me what the "NEW"...

Hiya guys I have this form called Quotes which is the main form for making a quote lol, it also contains a subform which lists the materails & Labour.. There is 2 buttons that have been created by someone on here ages ago for me.. the purpose of the buttons is BUtton Name (Create Base Order)...

Hiya Is there a way to force a user into adding information into a form? The form would be MyCompanyInformation There is default info in the form in the Demo mode such as Company Name : DEMO Email: This Is Required Contact Number: Demo When you start the Dbase for the first use, I want...

Hiya I have a form called Quotes with a subform within... I need to copy a record over to Workorders also containing a subform The idea behind this Once you have created a quote, and the quote has been accepted, then a workorder will need to be created. So rather than filling out all the...

Hey guys I was searching around and found this topic - http://www.access-programmers.co.uk/forums/showthread.php?t=111046 I took a look and managed to get it working, it sends an email using my BT Yahoo account without anyone knowing, no outlook or other client.. Now I can send a daily...

Hiya guys Been trying to finx this double booking issue since 1am lol Here is the code Private Sub Form_BeforeUpdate(Cancel As Integer) Dim Result As Long If IsNull(Me.fldDate) Then MsgBox ("Must enter Date.") Exit Sub End If Result = Nz(DLookup("[FldDate]", "BookingForm", _...

Hiya I have a popup reminder on my form splash screen that should only display if there are any work orders with "Awaiting Start" in the related tables, here is the code Private Sub Form_Load() Dim intStore As Integer intStore = DCount("[WorkorderID]", "[Workorders]", "[StartDate]...

Hiya guys I've got a popup reminder that starts on my home screen when I start access. It should popup a msg telling how many new jobs are starting, however, I can only seem to get it popping up on the day the job starts, I need at least 2 days notice Here is the code Option Compare Database...

Hiya I have a combo box on my form called "WorkProgress" it has the following within :- Awaiting Start, Job Complete, Work in Progress" Default value is set to Awaiting Start I also have these filelds JobCreationDate - (Date the Record was made) JobStartDate - (Date the work should Start)...

Hiya guys My Dbase is almost ready now for Distribution, but just a question... Is there a simple way to update this Dbase? The current version is 1, lets say there was a simple spelling mistake or something and the customer asked me to change it... Apart from giving him a whole new version...

Hiya Guys Anyone have any ideas for building Help Page System to go with a DBase? I think it would have to be called in by a button on the Menu Bar tho, can't seem to get anything going using F1 Sure there was a sample on here for a help system but can't find it anywhere ________ 3 Series (E30)