Search results

I have a split db. The front end contains a number of forms with subforms. On my remote copy I can see the subform. However when I pass it over to the server I cannot see the subform from the server or on my machine. Can anyone help?

I have built a split database for my customers. These databases are then personalised and distributed via WiseInstallBuilder exe software. The problem I have is if the end user holds the backend d/b in a different location the linked files cannot find the db. Have you any ideas to automate...

I know this is probably a very simple question but suprise suprise the help and manuals don't obviously state it! Does anyone know the maximum number of fields allowed in a query? Thanks

Hope you can help! I have a form which the users enters a serial number and a product code into separate input boxes. The product codes are held in a separate table with 3 fields -the start serial number, the end serial number, the increments they are counted in i.e. 3. I need the database to...

Hi I have a main table holidng my customers. Then another table with purchases. In this table multiple product can be entered and quantites for a customer. The product details are held in another table and details which product is in which product category. Exactly as Northwind. I need to...

Hi I have a main table holidng my customers. Then another table with purchases. In this table multiple product can be entered and quantites for a customer. The product details are held in another table and details which product is in which product category. Exactly as Northwind. I need to...

I have a major problem. I have been running reports on a table to check the first date of a date field against records on their Account Number. When I put first in the query window it actually brings up the last entry date for that Account Number. Any ideas what I can do?

I am trying to publish a report I have written into word. One of the fields is an OLE object which contains a bmp file. When I run the report it displays the bmp but when I publish it into word it doesn't. Is there any way of doing this as it is crucial I publish the report in word. Thanks alot

I need to produce a report to push into Excel for manipulation. I have a table which allows duplicate entries of the Primary key. It also has a date field for the date of entry. I need to find only the first entry for each Primary key. Then I need to process a report grouped by week of new...

I have a report set up with various subforms with 2 pages. When I publish it in word, it pops the occassional word down in the middle of the first page. It isn't consistent with the records each time I produce it and there's definatley no field or hidden field down there.

I have a report with 4 subreports in. The page is set to legal and has a margin at the bottom of 0.5cm. When I publish the report into Word pushes records onto another page approx 1/3 of the way down! It's driving me mad!

I seem to be unable to write If statements which looks in a field for a empty entries and entries which aren't empty. I know how to do this in macros, but I'm trying in subforms therefore need to do it in VB code. Also I need to find fields which contain certain things but can't use the...

I've set up coding to recognise a date. What I need to do is alert the user if the date is older than 35 days or more. It then asks the user to input another date (input box with a declared variable), if this is stil 35 days or more then it won't let them go any further. The problem I've...

I've set up a case statement to perform various tasks. The only thing is I can only get it to perform record by record. When I open the report I need it to run the code through all of the records. Any ideas?

Has anyone any ideas how to display a number field as words ie 123 one two three 0123 zero one two three

I have a field containing numbers. I need to display the field in reverse order. Any ideas how to perform this?

I am trying to produce automated printed cheques which require each unit of money to be listed in a separate box. The field it comes from is a calculated field. ie £120 the 0 goes in 1 box, 2 in another and so on. I have a formatted number field which is 7 numbers long. So all number are of...

I have a formatted number field which is 7 numbers long I need to extract each single number into separate fields on a report. Any ideas how to do this?

I'm trying to display a number field as a set amount of numbers I have numbers ie 10, 120, 4000 and would like them to display as 0010 0120 4000 Is this possible?