Search results

Hi, I wonder if anyone uses Apache Derby DB. Basically, I have been reading the Derby DB manual, but I can't find how to create an AUTO_INCREMENT field. Derby does not like this command. 'AUTO_INCREMENT' Any help will be very much appreciated. Thank you, B

rak, Thank you for your help. I could not get that code to work for me. I wonder if you have got an example please? Cheers, B

I tried this code; however, it did not know how to get it to work. I wonder if anyone can help please? What is this: rst!Account. I don't understand the use of ! Also, what does this line do please? fnGetAccounts = Temp

Hi, I am not sure what transpose do. I will look at it later. B

Hi, I am using a query to print information about customers and products on a report; the query is returning something like this: Customer---------------------Products cust1-------------------------------apple cust1-------------------------------cereal...

I tried all this, but it did not help. So, I just created a new form, cust and paste all the text boxes, lables...etc over to the other form. Thank you anyway.

I only use A2000 - A2003. I have no idea.

Cool, will give it ago then. I have a lot of queries with many search criterias that I use for search e.g. users can type a character and then all persons' names that start with that char will come up. Since, it's bringing data over a network, I thought that may slow the performance down. I...

Good article. Thank you.

It's a good article. Have you tried it?

I have done that before I loaded them into the server. But it did not help.

Hi, My DB is very slow when it's used by more than 1 person at a time. It's divided into FE/BE. The BE is in a shared server and a copy of the FE is in each person's machine. I don't know why it takes ages to respond. Any help will be very much appreciated. Regards, B

Hi, I sat my form properties to display both scroll bars, but it's only dispalying the horizontal one even though the form needs the vertical (a few text boxes are not displayed because they are at the bottom of the form). I have tried to close the DB and reopen it again and played about...

Yes I am using the docmd.transferspreadsheet. I was using the look up, but when I realized my stupid mistake. I am now switching to "formatting" as I tried it with the spreadsheet and it worked fine.

The results appear fine in my query when I run it. The change only happen when excel pulls data from Access! I don't quite know what you mean.

Hi, I'm importing data of a query to excel from access; however, all fields that have combobox for input display numbers instead of text. Any help will be very much appreciated. B

Hi, I tried using this formula to sum the agreed price which is a field in the table and the sum of vo price which is a field summed by the sum function. The query adds the values fine, but it asks for the parameter 'SumOfVO_Price' before running. totalPriceIncVO...

Hi, I used a tab control in a form. However, when I move the mouse over the form, the form flickers. Has anyone ever experienced the same problem? Thank you, B

It's alright lightray. Thank you for your help:)

Thank you alastair69