Search results

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, just an update I have spoken to the web host 1&1 and they have said that this package doesn't support direct MS Connections as its host on Linux server, therefor I would need to delete my current Database and upgrade to Windows Server to that allows MS Direct Connections. Can the stuff I...

Its hosted by 1and1 I have just emailed support to find out, probs take at least a day to hear back. Will let you know asap

Hiya Yes I have the tables setup already which are working and displaying correctly. I downloaded the ODBC driver, but for some reason it won't connect to the DB, I always get a 10060 error from SQL No way to link Access to mysql at the moment, so everything is done through PHP and Mysql

Hi Banana Thanks for your replt m8 The problem is, I have no idea how to do this in Mysql? THe tables are created in a basic state, no link etc as I'm still looking up on this Any help & advice you could offer, would be a blessing

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

Hi Bob Cheers for the quick reply I've tried to change it to .RecurrenceType = olRecursNever But it still shows up as a recurrence Any suggestions? ________ Easy q vaporizer

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 Cheers for the reply m8 Managed to get the old code working, found that I had an extra link in the Master / Child Links, I had QuoteID & WorkorderID. whereas it should've been just the QuoteID Silly, simple mistake lol But I will keep your suggestion in mind for next time, Cheers...

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

Its ok guys I found away round this I just added the fields I needed and changed a bitof the vba to include this Now if I click send on the form, I get am email from "Databank" with the following - Databank has been accessed by TestCompany at 09/01/2010 17:17:01 So now if someone is using...

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