Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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.

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 :-)

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

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

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