Search results

  1. C

    how to keep a form behind all others??

    thats quite right excpet of there are also controls (commands) on the form also. i could put them on another form but then come back to my original question.
  2. C

    how to keep a form behind all others??

    Hi All, I can't seem to find anything on this question which is... Is is possible to control the layer position of a Form. i.e. is is possible to denote that one form is always behind all others? The question arises when one uses a splashscreen form and that form doesnt have ability to move...
  3. C

    Retrieve Actual Value Rather Than Bound ID Number

    Technically though, why is it more efficient?
  4. C

    Retrieve Actual Value Rather Than Bound ID Number

    OK BOB!!!! I got it that way too :-) Here's the SQL SELECT TblEnquiry.*, TblEnquiry.AutoJobNumber AS [Job Number], TblEnquiry.jobstatus AS Status, TblEnquiry.jobowner AS Owner, TblEnquiryType.EnquiryType FROM TblEnquiry INNER JOIN TblEnquiryType ON TblEnquiry.EnquiryTitle =...
  5. C

    Retrieve Actual Value Rather Than Bound ID Number

    The missing operator error seems to be a difference in the use of brackets when using QBE compared to VBa
  6. C

    Retrieve Actual Value Rather Than Bound ID Number

    I've (Yeee Haaaa) answered my own question but for the benefit of others here is my answer: (there's not too much on the forum on this specific question) This goes in 'Field' in the qbe window: Job Type: DLookUp("[EnquiryType]","TblEnquiryType","[EnquiryTypeID] = EnquiryTypeID") Here's...
  7. C

    Retrieve Actual Value Rather Than Bound ID Number

    TblEnquiry doesnt hold the second value so the column count thing doesnt apply
  8. C

    Retrieve Actual Value Rather Than Bound ID Number

    my code so far: (doesnt work yet "missing operator") SELECT TblEnquiry.*, TblEnquiry.AutoJobNumber AS [Job Number], (DLookup"[EnquiryType]","TblEnquiryType","[EnquiryTypeID] = EnquiryTypeID" AS Expr1, TblEnquiry.jobstatus AS Status, TblEnquiry.jobowner AS Owner FROM TblEnquiry;
  9. C

    Retrieve Actual Value Rather Than Bound ID Number

    In my Db I have in tblSource two fields 1)SourceID, 2)SourceName ID1 / Telephone ID2 / Email The ID value is stored as the source of enquiries in a main table. I want to have a listbox which will show multiple rows based on the above principal. However, when i construct the query I only...
  10. C

    Select From Tbl1 Only where ID Exists in Tbl2 ???

    This is the code working correctly but minus the IP Address field I need: SELECT DISTINCT Last(radacct.RadAcctId) AS LastOfRadAcctId, TblPrimaryData.CustMacAddress, TblPrimaryData.CustID FROM radacct INNER JOIN TblPrimaryData ON radacct.UserName = TblPrimaryData.CustMacAddress GROUP BY...
  11. C

    Select From Tbl1 Only where ID Exists in Tbl2 ???

    Hi P, and thanks for your reply. Having spent 7 days solid on various aspects my brain is now hurting. I have two tables: TblPrimaryData & TblRadAcct Tbl PrimaryData includes a couple of fields CustMaxAddress & CustIPaddress These have to be updated from an external Db which TblRadAcct is...
  12. C

    Select From Tbl1 Only where ID Exists in Tbl2 ???

    If I have a table (tbl1) containing an ID "MacAddress" and I want to select corresponding rows from another Table (tbl2) which also contains MacAddress's but that table is very large. Can I do a query which only looks at records from Tbl1 where there is a corresponsing value from Tbl2?
  13. C

    Sql INSERT INTO Empty Txt Boxes??

    This code did it. I noticed Access caused debug prior to the script runnign so it was as string level but here it is as there's not too much on this particular question. 'Update Address Details To Primary Data Dim varPK As String varPK = Me.txtPrimaryDataID Dim strSQLUpdate As String Dim...
  14. C

    Sql INSERT INTO Empty Txt Boxes??

    Its great of you to help me out. Referring back to your earlier post. Do I first need to create the function?
  15. C

    Sql INSERT INTO Empty Txt Boxes??

    its runtime error 94 invalid use of null Dim varPK As String varPK = Me.txtPrimaryDataID Dim strSQLUpdate As String Dim varAddress1 As String varAddress1 = Nz(Me.txtAddress1, Null) Dim varAddress2 As String varAddress2 = Me.txtAddress2 Dim VarCity As String VarCity = Me.txtCity Dim varCounty...
  16. C

    Sql INSERT INTO Empty Txt Boxes??

    I got the nz additional part of the string and that works. But what if one wants the field to remain blank? How to handle blanks in systax?
  17. C

    Sql INSERT INTO Empty Txt Boxes??

    Will this work when the value is held within a string such as '" & [varString] & "'
  18. C

    Sql INSERT INTO Empty Txt Boxes??

    I am using A2207 and deploying runtime. Am using numerous strSQL strings and one strSql UPDATE. The problem occurs when the string involves a txt box which contains no data. A runtime warning occurs. Is there a way to make the string handle empty values?
  19. C

    Security / IsLoaded / Access 2007

    Here it is: The event in question relates to FrmResellerSearchSales Shitfty Key To Bypass User test / Pw test
  20. C

    Security / IsLoaded / Access 2007

    Its on the OnOpen but have also tried it on the OnLoad event to test trying to catch Access before it prompts for parameter
Back
Top Bottom