Search results for query: *

Hi all, My IT Manager has upgraded some of our machines to Access XP from 2000. This has caused the XP machines to show the database window via a taskbar button which appears on startup. I've checked that the box to allow this in the startup properties dialog is set to 'no'. BTW, some of the...

Hi all, I have a form for which I change the data source on the fly using command buttons. One of the fields on the form is named [company] which unsurprisingly contains a company name. The original data source for the form is a table ([tblContactInformation]). The command buttons change this...

Hi all, Apologies for re-posting, but I can't get this to work and it's making mey head spin! :-) I want to look up a form record for a specific customer using Dlookup via an invoice number which is stored in a field which is on a subform which displays customer orders. I do something exactly...

Hi all, Apologies for re-posting but this is driving me crazy! I have a control in a report which pulls together a set of values from various fields thus: Control Source = "Order Number " & [oldordernumber] & ", placed by " & [placedby] & " on " & [date] & &quot...

Hi all, I want to look up a form record for a specific customer using Dlookup and an invoice number and then move through some subform records to the order which that invoice number relates to. I did something similar using an order number (different field, text data type) which works...

Hi all, I have a control in a report which pulls together a set of values from various fields thus: Control Source = "Order Number " & [oldordernumber] & ", placed by " & [placedby] & " on " & [date] & " Type = " & [Type] To display an order, who placed...

Apologies for cross/re-posting but I got no joy in the 'reports' forum. Here's my original post: Not sure if I should spread this across two threads but here goes. I report sales from a database I have built, and have created a crosstab, which groups sales value per week by employee. I want...

Hi all, I have been trying to import some address records to a table from a word document. The problem is that the addresses have been formatted for labels. I have tried saving the document as a .txt file and then importing from there, but the conversion from .doc to .txt doesn't delimit the...

Hi all, A bit of background: I have a db used for processing orders for hospitality at sporting events. There is a main form with two subforms, one nested in the other - the subforms hold order information, the main client details. We run around 50 events a year. As part of entering an order...

Hi all, Does anyone know why my form's min/max and close buttons don't appear, even though I've set the properties to yes? Thanx in advance, Robbo ;-)

Hi all, In common with a lot of people out there it seems, I am having problems with sizing forms depending on screen resolution. I have designed my main form to 800x600 spec and to fill the screen, so when I run it on a machine set to 1024x768 it all bunches up in the top left. I've tried a...

Hi there, I have a very simple report which prints info on the contact history of a particular client. This report includes the field 'notes' from the client record (which obviously contains any notes about the client). The problem is this: When I preview or print the report, the notes field...

Hi all, I have a mainform [frmContactInformation] which has a subform displaying orders for each record [frmOrders1Subform]. The following code is designed to allow a user to enter an order number into a search form and move directly to the order record for that order number. The problem is...

Hi all, I have a report which details orders and which also summarises the value of all the orders on the report. The orders we take are assigned different types (FOC, New, Repeat, Credit, Contra) and I want to display a text box at the bottom which displays sum([Value])for all of the orders...

In a nutshell: I am investigating the ease of connecting remote palmtops to an access db via the web. I have very little experience of programming for palmtops, is this easily learned? Are there visual development tools available that I could use to flatten the learning curve? What about on...

I have been forced to change the data type of a field which I use to find records on a subform (too complicated to explain, but not uncommon for my employer to change their mind about what they want) from number to text to allow the use of alphanumeric codes. This has now produced a problem in...

Hi all, I have a set of reports which show Order information based on various criteria. The report is sectioned as below: rptHeader - Report title & Company logo OrderNumberHeader - Order number, date of order, person that placed the order, company that placed the order & order type. Detail...

My database file has become corrupted and my backup (made with MS Backup) will not restore for some reason. I just get a message saying that 'the destination file does not suppport all of the features of this file so some features may not work' or something along those lines. I then try to run...

I have a form with a subform, which in turn has a subform. The second subform holds details of products ordered, the first subform details of the order and the main form holds client contact data. I want to make sure that my users will complete all of the fields on the first subform before they...

Hi all, I am having a problem moving to the correct subform record when opening the main form using a DLookup routine. What I want to do is open a form which holds client details which has a subform which displays order details. The user enters an order number into a search form, clicks a...