Search results

So I can't get a scrollbar's scroll unit? That kind of sucks. Reason why I want to do this is to save the user's previous viewing position, so that the next time the user reopen the form or application, it'll pop back to where he/she was viewing last.

I have a form that has vertical and horizontal scrollbars. How do I get the x and y value of them? (i.e. to see which portion of the form the user is viewing...)

I'll try it out...thanks.

Say I have a table [tbl1] and a recordset [rst1]. The fields in both items are the same. Now, how do I copy/dump/inject (what's the correct term?) the data from the recordset into the table?

hum....it doesn't seem to do that I want it from this: [CODE]SELECT dbo_QuotedAirRates.QuoteID, ('Min: ' & formatcurrency(IIf(isnull(dbo_QuotedAirRates.CustMinimum),dbo_QuotedAirRates.Minimum,dbo_QuotedAirRates.CustMinimum))) AS Minimum, ('Less than 500: ' &...

Thank you so much! That's all the info I need really. I totally appreciate your help in this matter.

But how would the report known when to do the "sliding"? I'm soooo new to reports...sorry. When does a query carry out when a report is open? Also, when a report opens, is there some kind of before/after[action] that I can run the self check (such as...if column 3 is empty/null then shift...

Anyone know a solution?

I'm trying to make a report where sometimes there'll be 2 columns, sometime will be 5 columns...or maybe 4 columns. (User select which columns they'd like to show in the report/printout). The question is, how do I make these columns all pack towards the right hand side of the page? Here's an...

I'd like to know this as well. Is there anyway to get the columns/fields header/name via VBA when given a table name? Or maybe some way to return the number of fields/columns there are in a given table....

Everytime after I save a query, all the layout/formatting is lost. And the next time I open a query in SQL view, it's all sqeezed together again. I don't like that. It's not easy to read. Can anyone help?

Doh...I found the answer to it. Stupid me... (Application.currentuser)

How do I get the username of the logged in user (Logged in to the Access workgroup security)? I know how to get the username of the computer/system. But how about those who log in to Access?

Thanks man, you're the best!

Thanks, I just tried the @@Identity in Access 2003, works well. Not sure if it will work with Access 2000, or do I only need to update the JET on the client computers (those with Access 2000) to get this @@Identity feature working for them? Thanks for the tips with the rs, I'll keep that in...

Next question, but related: What if I'm using an unbound form and that new records are add to the table via ADODB.connection and ADODB.command? How do I get the autonumber (ID/identifier) of the last (newly) inserted record of my current session?

Why do you need the algorithm when there's already a function for it?

Sweet!!! Thank you! ;)

Inserted via bounded form in with "allow addition" & "Data entry" set to yes. If it was an SQL server, I'd have used "Select @@Identity"...I need something similar but for Access's own Jet database.

When I insert a record that consist of a field that is "autonumber"...how do I get back the value of that into my VBA code?