Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lopster10

    Traffic Lights in Excel

    Hi Guys, I am currently working on a traffic lights system for an excel spreadsheet. I have 2 date columns and a colum to indicate the colour. So Target Completion || Current Completion || Status I see the logic as.. If target completion is in the future, colour is green. If target...
  2. lopster10

    Matching data

    Thanks very much for the help. I did attempt a vlookup but must of had something wrong as yours worked perfectly, Cheers Lopster
  3. lopster10

    Matching data

    Hi there, I have a problem but am really unsure of which function to use to get the correct data, I have tried a number of different approaches to no avail. The spreadsheet contains a lot of data but too try and cut it short I need to this: I have a load of customer ID's in Col A. In Col M...
  4. lopster10

    Restricting access to forms

    Hey there, The application is vb 6.0 front end and an access 97 database which is stored on a shared network drive. So really just something like If frmXXX is open display a message to say its being used by another person. Any ideas appreciated
  5. lopster10

    Restricting access to forms

    Hi Guys, Just been looking about the net for some help with stopping multiple users accessing a particular part of an application. i.e If one user has a booking form open, the other user is informed its currently in use and cannot open it. I havent found anything very useful so was just...
  6. lopster10

    Setting date format in SQL query

    Hi Guys, I have a simple Create table query but I need to set a field to a specific date format, that being dd mm yyyy. If I just leave it as default "Date" then it returns as dd/mm/yy. How can I set the data format within the Create table query string for that field? Or do I need to achieve...
  7. lopster10

    TransferText Method

    Ahhh Ive finally worked this out from chance. When the temp table was created, I right clicked and exported, this also game me the option to re-create the specification file to include the new field name. After doing this the function worked perfectly. I still dont know how to view the...
  8. lopster10

    TransferText Method

    Hi Guys, I have a access application which uses the TransferText method to write some data to a text file. Basically a temporary table is created, then the single record which populates it is written to the text file. If I add another field to the create table query, I get an error saying...
  9. lopster10

    Query using listbox value

    Hi Guys, Yeah after taking a further look into it I also realised it didnt actually make sense. But PHV your example worked perfectly, thank you.
  10. lopster10

    Query using listbox value

    Sorry I meant to write: ('" & listvalue & "');
  11. lopster10

    Query using listbox value

    Hi Guys, Im new to SQL and am trying to use the value from a list box to then use in a query. I am using the following syntax: DoCmd.RunSQL ("INSERT INTO tableName (fieldName) VALUES ('value') WHERE tableName.fieldname = ('" & listvalue "'); ) So basically in the list box they are selecting...
  12. lopster10

    Setting a default option

    Hi Guys, I have a form which when loaded displays current email addresses in the database. From this screen I can add / delete email addresses, but im trying to implement a new function where I can select an email address (from the ones displayed in the listbox) and set as default. On another...
  13. lopster10

    Using field data to generate a query

    Sorry! Im pretty new to VBA and I have just realised how to do it after seeing the word Recordset! Thanks
  14. lopster10

    Using field data to generate a query

    Ok, thanks for that, just 1 more question.. Is it possible to assign the return values to variables within the query statement So if for example I had the following: "SELECT tblPersons.[Start Date], tblPersons.[Expiry Date] FROM tblPersons WHERE tblPersons.[Name] = '" & ValueName & "';"...
  15. lopster10

    Using field data to generate a query

    Hi guys, I have a combo box which is populated when an Access form is loaded. This selects all users from a particular location, and then displays the data within the combo box as Surname, FirstName. The user can then select the necessary user they are after. (So the 2 values are put together...
  16. lopster10

    New to VBA - for loops

    Ahh thank you very much, I wasnt thinking about how the individual fields would be returned, my bad. Regards
  17. lopster10

    New to VBA - for loops

    Hi guys, I've literally starting learning VBA a few days ago so plz keep that in mind:) I have learnt some of the basics, but im just looking at DAO. In the following statement, what is the purpose of the - 1 ?? Why is this needed? For i = 0 to db.TableDefs(0).Fields.Count - 1...

Part and Inventory Search

Back
Top