Microsoft Access / VBA Forum

Access 97 I have a memo field in a footer on a subform. When I print the form, all data is printed except the data that was entered into the memo field. The memo field itself is printed (the border), but the data is missing. The following properties are set for the memo field: Visible: Yes Display when: always

Using AccessXP - Access2000 In my application, when an order is entered, inventory is automatically adjusted, a pull list is created, items are pulled to fill the order, and the order is packaged for shippment. The order is then held pending payment and finally shipped when payment is received. Sometimes prior to shipment the customer calls...

I am hoping someone can help me. I am making a Access 97 app for a person and have run up against a problem to do with MS Graph. There is a table that has a number of data elements and a date field and entries are entered each month. A graph is required that has three of the data elements represented basically on the y axis and time as months...

When I open my form nothing is selected in the list box. After making a selection it stays highlighted. I have been trying to get it back to the "nothing selected" state, but with no luck. I have tried repainting, requery, etc. Thanks for any help, ShyGuy

Does anybody happen to have any idea on that: Why in MS-ACCESS 2000, when closing the tables , I get the dialogue message box (asking if I want to interrupt the code being running) with Yes No options, and Yes is not accessible, so that closing the table is finally impossible!!? MT

Sorry for my previous post in italian language. It was a cut 'n paste problem :-) ============================================================================ Do you know how to reach and use it? In article number 290293 from Microsoft KB you can read: "After you customize the properties for the Application.Printer object, set te...

Advice greatly appreciated in in finalising setup for data entry : After splitting mdb should an MDE be stored on each local workstation and the data stored on the server? Should individual user accounts be setup - if so are there any specific requirements to be aware of. Does this eliminate user locking? Are there any other specific...

To begin with an example... Let's say you were wanting to write code usign early binding to the MSXML library, but then be able to switch between early and late binding at will. Conditional compilation is one possibility, but it's not practical. 1. You have to put a precompiler condition block around every Dim and every function...

I have a report with one level of grouping and a running sum field in the detail section of the report. When I make the running sum field visible, I can see that it increases the count by 1 for each record in the group, just as it is supposed to do. However, when I place a field on the page footer to display the total count for the group,...

I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo field, and it works. But, it seems wrong since I had to create a huge text box to accommodate memo fields with a lot of text. Thanks for any help,...

I wrote a Delphi application that accesses a local Access database using 2 instances of the TADOQuery class. Unfortunately, when I traverse the DB records using the first TADOQuery instance, the pointer to the active record maintained by the second TADOQuery instance is also affected. Is there a way I can force Delphi to use a seperate...

How can i make my Else..If statement make look no so cumbersome? Besides the condition for previewing the report doesnt work,may be my If condition does no apply properly. Perhaps this is due to the many conditions in my If else statements. Do i have a mistake in my function CmdStockReceipt ? Private Sub CmdStockReceipt_Click() Dim f...

I'm building a simple flying logbook. I have a table with the registrations of all the aircraft I have flown and what type of aircraft each is. I am now building a form to input all my flying data into another table. How is it possible for me to input aircraft registration in one field and have the aircraft type automatically placed in...

Hi there, I have been stumped by a where statement! (Thought it would never happen!) I have a database that stores parts of postcodes for a survey to see where our customers have traveled from, and I want to query it to produce count totals in a report. I have already built the report and it works good querying the data as I want it,...

Hi All, What are people's experience in timing Query Performance? I have tried in vain, but get many unpredictable results, with execution proceeding in the background and problems of timing precision. I am trying to assess my applications performance difference using FK using BYTE instead of LONG type. and not enforcing integrity at the...

I've got a combo-box drop down list with 2 columns. Both these columns are displayed in the list. But only the primary column is displayed in the field once I've made my selection from the list. Is there any way I can display the information from both columns? Thanks Kevin

done homework on Usenet and still stuck... I have a parameter query that asks the user to input the 'slip reference' based on the accounting period. This has now changed slightly so that the slip reference number is based on the date, so for instance if the date is as follows, the slip reference is as follows: J12345 21/08/2003 J12346...

Hello, I created and worked on my application on my desktop and copied it to my laptop. After putting in many additions to the functionality on the Laptop version, I copied it back to my desktop. Nothing was changed on the desktop in respect of the configuration but I now get an error which I am unable to fix. I have a statement "Set...

As this is the only technical newsgroup I read and contribute to I hope it's ok to ask a quick bit of advice about small footprint monitors. Basically I can't find any info about these kind of monitors and the online suppliers that are based in the UK don't feature these as a sub-category. I want a monitor that doesn't claim half my desk...

I have a TransferSpreadsheet action in my macro where I want to export the results of a select query into excel 10 named "Query1". I type in the name of the query into the "table name" field and I type the file name of the excel spreadsheet into the file name field. However, when the macro runs, I get an error that the database engine can...

Hi Is there a reliable way to place a 'number of concurrent users' limit in vb.net applications? Thanks Regards

I am looking for a dll or ocx that I can use with Access to create time charts. Could anyone point me in the right direction please. Alex

Maybe this isn't as difficult as it seems, but cannot get it to work correctly. I have an Access 97 Form which contains 12 separate rows of text boxes that are used for entering monthly sales information with dates and amounts. What I'm trying to accomplish is having a Query to scan each of the rows and be able to show data from one row or...

I am using MS Access 97 DB to store information and connecting thru ODBC. Something really weird happenned....one of the tables went missing and all the data in that table got lost.... How can that happen? Is it possible?

I am using MS Access 97 DB to store information and connecting thru ODBC. Something really weird happenned....one of the tables went missing and all te data in that table got lost.... How can that happen? Is it possible?