Search results

nope, that causes other problems. Here's the code (complete) as written for Ac2, which might help someone to figure a solution: >>>>>>>> Function GetNextCounter (ByVal strtablename As String) As Long ' Returns the next custom counter value for a particular ' table. Counters are...

No ,but problem more confusing than I first wrote. The following code comes right after the code I originally wrote: >>>>>>>>>>>>> 'EDIT FOR COUNTER TABLES IN SAME COUNTER.DB Set recCounter = dbCounter.OpenRecordset(strtablename & "_EntryNum", DB_OPEN_TABLE, DB_DENYREAD)...

Hi: I'm trying to convert an AC2 Db into AC2000, and am having a bit of trouble with the following code. This is to serve to get numbers from a 'counter Db". >>>>>>> Dim wrkCurrent As WorkSpace Dim dbCounter As DAO.Database (I've added the 'DAO." for AC2000"--not present in the original)...

Perfect! Thanks

I'm in the process (beginning) of trying to update a Db written in Access2 basic into visual basic for access2k. I have the following code: "If IsLoaded("Form1") Then------", which is not suitable for visual basic. Can someone explain how to change this code to use the 'isloaded' property...

What a simple solution!!!

I'd like to use access to issue letters to individuals. There might be > 1000 characters of text in each letter--far more than can fit into a textbox item in an underlying table. The underlying table has items such as 'addressee' 'date of letter', and 'title' as its rows. Can anyone suggest how...

1)Yes, of course it would be a subform to a "calendar". 2)Separate table for people is only good if you have all appropriate info for these people to be able to enter them into the Db table. For new clients not yet seen, its easier to just set it up as a table. Depends on how you want the...

Rooms.mdb sure looks good to me! Thanx. Bytheway, you sent 2 attachments of rooms,zip. Are they identical?

Hoping that someone can guide me in the right direction with the following problem. I'm trying to create a schedule subform, which would show fields for : 1)Time-in 1/2 hr intervals from 8AM to 2PM 2)room numbers 1 to 4 3}a field to enter/display customer name and service planned for each time...

like I said, each letter is generally a 'one of a kind', with perhaps one copy to somone else. The ONLY variable is the adressee info, and all letters are different text. What do you think is the best way to go?

Hi; I have a database table in msAccess with names/addresses/etc. I have to send text reports to INDIVIDUALS from that mailing list. I'd like to write text into Word, and be able to enter the addressee name automatically in some way. (Note that I'm not at all familiar with 'mail-merge', whatever...

Just realized that I'm having difficulty including a parameter in the form recordsource. I'm using: SELECT DISTINCTROW SERVICES.* FROM SERVICES WHERE ((SERVICES.InvoiceNum=[Enter InvoiceNumber])); When the form opens, I'm getting a prompt for the parameter, but the tform opens with no fields...

thanks. It would just be so easy to click a command btn and open a query on screen, and I was hoping-----

Hi; Is there any way of defining a select query (in AC2) as SQL, and opening this query from a code using 'OpenQuery' method or 'RunSQL' as the operand?.

Hi: I'm trying to use the following code: >>>>> rst.MoveFirst MySQL7 = "UPDATE DISTINCTROW TBillDetails SET TBillDetails.InitBD1 = "", TBillDetails.LastBD1 = "" " MySQL7 = MySQL7 & "WHERE ((TBillDetails.linenum = " & rst.linenum & "));" ---runSQL MySQL7 >>>>>> When this runs, I get the following...

thanx. just of note, I tried " Where rst.[fieldname] like '9*' (single qoute) and that did work. God knows why!

HI; I'm trying to set up rst by means of SQL in code. Part of String is -Where rst.fieldname Like "9*" -. This parse works just fine in query widow, but doesn't compile. Any suggestions? TIA

Hope someone can help with the following: I'm using Acess2 and am trying to run the following query in a sub function. MySQL = "SELECT TOP 1 (DMin("[Date_From]","services","[clientID#] = a and [payer] = b")) MySQL = MySQL & "AS x FROM SERVICES;" When this line is compiled, I get errmsg of...

>>>> Yep, that works nicely. Thanks