Microsoft Access / VBA Forum

Hello, Apologies for raising this issue again. I chanced on a piece of code in Chapter 19 of the Access 97 Developer's Handbook - specifically Listing 19.3. This listing refers to "Retrieving a List of Fonts" precisely what I was looking for earlier - albeit in Access 2000.

Hi I want to resize a form so that before it prints, it fills up a portrait US Letter page. I am trying to use Docmd.MoveSize to make it quite high, though the action will only stretch the window to the limit of the Access window. That would be OK if the users were at 1600x1200 resolution, but it's not OK if the are at 1024x800.

Hi all, Using Access 97 Front End, linked to SQL Server back end. Required data is spread across three tables, with one table linked one to many to the two others. I created a report based on one child and the master (inner join), which works properly and loads to preview in less than a second. Created the second report using the third...

Since reading values from calculated controls in Access 2000 and 2002 from code has proven unrliable at best, and since I like to avoid running separate queries to calculate sums of subform records since they can give inconsistent results if there's more than on interface or user with access to the table, I wrote code to loop through a...

Where can I find some info on grabbing the recordID of the last record, incrementing it by one, and using the new number in a new record.

I have a client who can't get off of Access97. I want to use the InStrRev function, but it's not available in 97. Is the function's code available? Is there any equivalent functions for 97? Thanks in advance.

Greetings all, I am looking for the best way to move data from one access database to another. I have an Access database, an older version. I need to move the data in the tables to a new access database. The schema in the new database my be a bit different. What is the most efficient way to do this many times? The old database is...

Hi, I am a beginner in Access. I want to do a form that there is a combo box and an edit box. I have a table with Customer ID, Company Name and Country. I want to do that when my combo box chooses an item(Company Name) in the form, the edit box can show another item (Country) after the trigger. How can I do that? Thx very much! Raymond

Ok here goes, 1 table access by a query. Query shows 2 Apples and 3 Pears only. Since there is no Oranges record found in the table. Apples Pears 2 3 How do I include in the report the Oranges? Since there is no record found/created yet which I know there is Oranges available but not sold yet. My report would include the...

In an InputBox I want to get numeric data. This works wel until u use the decimal seperator on the numeric keyboard. In the country settings the decimal seperator is set to a , In all apps this is recognised but in the inputbox a . (dot) is recognised. In my VBA app the dot is ignored so instead of getting 1,5 (for instance) you get 15. Dus...

Hi to group, I'm a student of M.C.A. from B.I.T. Ranchi...I'm in my project period here i have to migrate the MS-Access database table to Oracle data base tables...so, please help me in getting this....if possible plz send me the sample code.. thanking you,

Hi All, I'm using Access 2000 + MySQL I can setup a DSN manually and connect via ODBC but it's a bit of a PITA What is the smart way? Can you connect without a DSN or can you make one programatically

I have a rather complicated function for updating from a list box called ListInvoices I want after updating to have a message saying " Invoice number ... has been updated."The invoice number should be equal to orders.invoiceId in my strWhere clause shown below.Can somebody help me ? strWhere = "orders.InvoiceID = " & Forms!!.Value Dim...

(MS Access 2002) Hello, I'm working with some big Census (PUMS) files, and I run into a peculiar problem once the data field exceeds five integers. I'll explain every step, since I am doing it in a somewhat complicated manner. 1. I filter the data to include only those serial numbers (field name) that include a specific value in another...

I print to a device that creates a PDF. Knowing the filename, how can I then embed the PDF into the body text of an OutLook Express outbound email & send to a specified address in a table? I want recipient addressees to see the report in the body text window of their email when they open it. I was thinking also about attaching the PDF file to...

Hello, I'm having trouble converting code in Access XP / 2002. I have some code that declares an variable "as database" in Access 97, which is not recognized in Access XP. I've tried to find a refrence to the items that have changed between 97 and XP, and haven't been able to find anything yet. I will continue looking, but if anyone can...

I am trying to place a company logo on a form but try as I will I can not get the transparent parts to stay transparent. Is this even possible? If so what file format does my picture need to be in..... have found that the TIFF format seems to maintain better quality over GIF or JPG on the small type and line art. Any secrets or advise most...

First of all thank you to all those who have helped me in the past, as I have stumbled along with MS Access 97. My question this time is more of a general one in nature. It seems obvious to me now that what the client needs is a stand-alone programme. To that end I have begun looking at menu building and the like. What I need to know, and...

OK, try to follow me folks; I have three tables, connected like this; FLIGHT---------< STOPS ------------< LOAD NOW, I need my app to count how many stops have NO load. How can I do this in a query?? Thanks in advance folks,

Hi I am new in this forum. I develop in access 97 and I made some tables and quires that take sum or organize the data in the way it need. I have a table with receipt that I have the sum of the receipt on a quire. I need to put the data from a quarry in this location how can I do it? Thank you for your help

Does anyone have suggestions on how to print report odd pages only? Greg

Can some one give me some "air code" to open a form in datasheet read only view. This... DoCmd.OpenForm "anyform", acNormal, acReadOnly ....will open my form and I can toggle back and forth between form and datasheet view. I would like to start in data sheet. Is there an alternative to "acNormal" that will force a starts in datasheet...

I need to be able to enter an elapsed time into a text field. This time then needs to be converted into seconds and stored in a field in some table. The user will enter a time (format is h:minutes:seconds) as such: 0:15:34 (0 hours, 15 minutes, 34 seconds -> 934 seconds total) or as another example:

IF I have a database developed in the following environment: Windows XP Professional (all security patches and critical fixes installed) Office XP Professional (Access 2000 file format in Access 2002) And tested in the following environment: Windows NT SP 6.1 MS Access 2000 (9.0 27200)

Hello, I am new to access/sql-developement and have the follwing problem: What I finally want, is to present within a form the results of a query, that are probably read-only PLUS a field WITHIN each record to store extra data entered by the user. The problem is, that the query outputs a read-only dynaset, so that my extra-Field is also -...