Search results

pfPositionCursor is a User Defined Function that should be placed in a Standard Module that does not share a name with any procedure. The code for pfPositionCursor() is found post #4 of this thread.

You can't with this code, sorry.

It would be helpful for us to see what the SQL View (your SQL Statement) of your Query object is. But even without that, your expression does not return the correct value. Please give the following expression a go ... DateAdd("d",7-Weekday([scheduled_date], 7),[scheduled_date]) The 2nd...

Description ... This utility will log the users who are connected to an MDB/E or ACCDB/E file via the UserRoster feature of the Jet/ACE database engine implemented with the introduction of Access 2000. In addition, the utility can manage the Connection Control (aka: Passive Shutdown) property...

You're welcome! I am glad to here of your success!

Beleive it or not, you can modify the structure of the table that is represented by the linked table object fairly easily ... just provide the "Fully Qualified" path to the source table via the .Connect property of the linked table object. CurrentDb.Execute "ALTER TABLE [" &...

I personally find the code found here named MakeCSV() to be easier to use and more flexible --- Not that I am biased or anything :)

As Paul indicated, the .LastModified is relative to the Recordset object variable. But I have to ask -- Why would you enter data through a Query object? While it is possible, it is often times less efficient to do so. In addition, since you are just ADDING data and using a recordset object to...

>> A date is simply a Long number << As an FYI. A VBA Date and the Date/Time datatype in Jet/ACE is an 8 byte floating point number (a Double) with the whole number representing days from a base date of 12/30/1899 (US format). The decimal portion represents the portion of a day passed...

<big sigh> .. I am saddened by this news and priveledged to have coincided with Dave on these forums. Sympathies are extended to all.

So assuming that you have a custom group named "History Only", you will want to go into the table MSysNavPaneGroups and find the row that equates to your custom group name. You will want to remember the Id column value. We'll be storing that value in a VBA variable that we'll call lngGroupId...

I don't have an example of modifying the data in the MSysNavPane tables since I subscribe to the belief that you really should not have a need to do so. :) Can you review with us why you would like this task automated? Not that you have to justify it, but often time people think they need to...

What version of Access are you using?

Ok ... it seems there is a disconnect between what you are asking and the response you recieved. That much is obvious. With that, it would seem, you should take the time to look at your question, as well as the response and see how YOU the questioner can explain your goal more clearly in order...

The v1.6.1 is what I am using (attached it to the post). The 128 character limit is something I can not control. As far as being able to kick someone (or everyone) out of database, you have to set up some stuff first. The general premise is this ... - Create a table in the BE that has a...

What are the environments that you are both working in? ... Win7 (64/32 bit) / WinXP?; Access version? As an FYI ... I just downloaded and successfully ran the utility that is attached to post #3 of this thread. I do have a different version that I use (I can't remember what I changed) and I...

Hello Doc! ... Just a point of note .. l = 255 + 1 Will not raise the overflow error because literals are cast as 2 byte integers or higher. However, to illustrate you point, the following WILL raise an overflow error... l = CByte(255) + CByte(1)

Very much so, I am just used to using VarType() ... :)

This has to do with the type of the operands. VBA will imply the datatype of numerics into an Integer, Long, or Double if no datatype is specified. When you perform operations upon the operands, VBA will assume the result to be of a datatype that matches the "heaviest" datatype. So ... ...

Sorry 'bout the dup info ... Bob and I racing to get the finish and his speedy internet prowess beat me to the punch! ... :D ... But ... do take a look at the full value of DateSubmitted from the attachment I posted ... you will see the fact that your DateSubmitted set of values do include...