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 Chriss Miller 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. apkohn

    Show all members with qual that comprises multiple competencies

    Thanks Remou. I hadn't thout of comparing the number of comptencies attained in a qualification, to the total number required in a qualification. I was stuck in the mindset of thinkng: For each competency in qualification, make sure the member has it.
  2. apkohn

    Show all members with qual that comprises multiple competencies

    Hey all, this is a bit of a tricky one (well to me at least). I have a database to record the training qualifications of members. To get a qualification, you have to pass all the designated competencies for that qualification (each qualification can have 1 or more competencies). Now the...
  3. apkohn

    Using built in functions through automation

    Hi all, I have an Access database that uses a function to send some information to Word, using VBA. Now, I want the Access function to call an input box in Word (ie displayed modally in the Word window, not the Access window). The result will then ned to be returned the the Access calling...
  4. apkohn

    Pad out query with all dates

    Oops, I mucked up the second table. There should be a column for the "Reading", which will read Null if the line is created. Also, I am aware that I can create a table with every calendar day in it, and join it to the above table (showing all records in Calendar), but would like to...
  5. apkohn

    Pad out query with all dates

    Hey all, I have a table in my database that has a reading recorded against a particular date. eg: ReadingDate Reading 16/01/2001 100 18/01/2002 250 21/01/2002 150 Now, I would like a query, that will return a record for each day coverred in the above range. For example, I...
  6. apkohn

    Server Date & Time

    Just to place a comment against my own code above, I would make a change. Where I have the line dateServerDate = DateValue(.tod_day & "/" & .tod_month & "/" & .tod_year) I would swap that for a call to date serial. This would prevent any issues withh dd/mm/yy vs...
  7. apkohn

    Get user login name

    Just a note, that if you use Username a lot, then the environ call is a lot faster than the API call. However, as John stated, it is not necessarily a reliable function. An alternative, that isn't quite right for an app that I have used the API in, but my future designs will use it, is create a...
  8. apkohn

    VBA and Text direction in international versions of MS Word

    Hi all, I have written an Access 97 database that can output a report to Word. The report includes Columns and Tables. Now, the database was developed in Office 97, without any support for international (right-to-left) languages. However, one person that needs to use the program, runs Hebrew...
  9. apkohn

    Date Function Parsing problem

    Hey all, I have a program that needs to parse a two strings into a date type variable. The first string contains the date in yyyymmdd format, whilst the second string is hh:nn format (well they should be, so I need error checking too). Anyway here is the code: Public Function...
  10. apkohn

    vbYesNo MsgBox Functionality

    I personally prefer this approach for readability: Dim intResponse as integer intResponse = msgbox("The Text", vbYesNo) if intResponse = vbYes then 'Do something else 'Do something else end if I know it adds an extra variable, but I find it easier to read, and maintain...
  11. apkohn

    NotInList Event + Formatting = Problems.

    I had a similar issues, in that I wanted to select a record from a drop down list. The numbering convention is for 4 digit numbers (ie 0001, 0002 etc..), but want users to be able to type 1, 2 3 etc... as well. As such, this is what I did: Private Sub cmbGoTo_NotInList(NewData As String...
  12. apkohn

    Using # in SQL Queries

    Alternatively for those of us that use correct date format (dd/mm/yyyy) you can try &quot;SELECT * FROM [TABLE] WHERE [Date] < #&quot; & format([TheDate],&quot;mm/dd/yyyy&quot;) & &quot;#&quot; Its a pain, but reliable.
  13. apkohn

    Create a date stamp when record is saved

    GingerR, Just scrolling through the line of posts and stumbled across your first post in this thread, with regard to environ(&quot;Username&quot;) I have been using a function pulled from www.mvps.org/access, called fOSUsername() to get the username. This function uses API calls. Now the...
  14. apkohn

    A Bound Multi-Select Listbox - Is it possible

    I wish to have a listbox on my form, that enables a user to multi-select a number of items. Currently, the only way to work this, that I can think of, is to make the listbox Unbound, and use code to read and write from the database, and then display. Whilst I have no problem in writing the code...
  15. apkohn

    MS ProgressBar Control, Ver. 6.0

    I have actually written my own progress bar, rather than using the Minrosoft one. Basically, I created a form (frmProgress) that has two boxes on it, plus a label. Then in the module for the form, I have created a number of properties, that let you set what text the label will display, and set...
  16. apkohn

    Mail merge from Access

    Just a follow up, I aborted the mail merge idea. Now I simply generate a new word doc, through automation, and place all the data in the doc via vba code.
  17. apkohn

    Deleting the Mailto: from an email address

    You could also try: If left(stDisplayText,7) = &quot;mailto:&quot; then stDisplay = right(stDsiplayText,len(stDisplayText)-7) end if Though i have to say that Tranman's looks neater :-)
  18. apkohn

    Detecting which Index is causing Err3022 (Duplicate values in Index)

    I have a table that has a number of fields, that are Indexes with No duplicates permitted. Programatically adding data to the table in VBA, there is a slight chance that the Word Doc that a user sets up to import the data may have duplicates. Now, for each field, I can overrule what the user...
  19. apkohn

    Code to kick off linked users before maintenance

    MichaelRed, Ok, let me rephrase that. I don't believe that you can use the Access 97 security to determine who is connected to a database. In fact, quoting from www.mvps.or/access, <tt>In Access 97 and earlier versions, there's no built-in way to get a list of all users currently using your...
  20. apkohn

    Code to kick off linked users before maintenance

    I would do something even easier, if you don't use the security stuff (I don't even think the security stuff works in A97 but vould be wrong) Anyway, why not have a table in the backend, that you set up and has a field that you set to true if you want to maintain. Then, the front end can do a...

Part and Inventory Search

Back
Top