Search results

Hi, I have a standard Laser Printer called "Lexmark" which I obviously use to print my reports onto paper. Occasionally I need a PDF copy so I open the report, click "Print..." and select my "PDF Printer" to make a PDF version I'm now requiring equal amounts of printed paper reports and PDF...

Hi, Does anyone know how to change the properties of a multi-lined text box so that when you press the enter box, it moves down to the next line, rather than moving to the next text box. At the moment I hold down Control + Enter to move down to the next line, but I want to do the same without...

Hi, I'm trying to export a report to a text file. The report contains a pound "£" symbol, however when it is exported into a .txt file the symbol appears as a "œ". Does anyone know how I can stop this from happening, or the symbol that would make a "£" appear. Thank you. Dean

Hi, Does anyone know how to identify a word in a string? I have a field called "ImportCSV" which has upto 1000 characters. i want to apply an if statement to the code of an event button on my form. For example... if "ImportCSV" contains the word "Goldmine" then do this else do this I've...

Good Morning, When I normally parse a string or csv I use the split feature and the delimiter used (I normally use the ">" symbol as commas come up quite often and mess it up). However I now have the problem of trying to parse data that someone sends me and I don't have any control over the...

Hi, I have a field "DisplayURL" that contains values of various lengths. Some are only 12 or 13 characters long, but others are 50 characters long. I need to run an update query to "cut-off" all the characters past the 35 limit - so that all records in the field will be 35 characters or less...

Hi, I'm trying to run an update query on a field called "DisplayURL" to remove all of the spaces that the field contains. Some have 1 space, some 5 and some have no spaces. I'm using Access 2000 and the replace function ( Replace("DisplayURL"," ","") or Replace([DisplayURL]," ",""). However...

hi, I have a table that contains itemcodes and prices. An example of the records would be: <Item Code> <Price> Product001 £34.56 Product001 £49.23 Product001 £23.22 Product001 £98.43 Product002 £12.45 Product002 £54.34 Product002 £25.51 Product002...

hi, I have created a search form based on a table, and a macro to show a list of my customers. If you press "C" it only shows customers whose surnames begin with C. However I've really been struggling with how to filter the names into alphabetical order as well. For example, the following...

Hi, Here's what I'm trying to achieve: By Clicking command button "GenerateButton" on the "OurProductsTable" form it outputs the text below to either a msgbox, or ideally a notepad file. [OurProductID] in the text below would be replaced by the field [OurProductID] from the "OurProductsTable"...

Hi, Does anyone know if its possible to have a page break/line space in a query's results? For example, a query returns 5000 results, and after every 45 there is a space of 2 or 3 spaces. When I say "space" it could be a couple of empty records or rows. The reason I ask is because I use a...

Hi, I have two text boxes that contain two number values, "test1" and "test2". I currently use the following code to check that the values match: if test1=test2 then msgbox "Correct" else msgbox "incorrect This works fine, however I want to be able to check they match "plus or minus a penny"...

Hi, I have a form called "InvoiceForm" - on this form are two subforms called "NewPurchaseTable" and "TheirPurchaseTableQuery". Below is a screenshot of how "InvoiceForm" looks: I have blanked out other columns that are irrelevant to this problem to avoid confusion. What I am trying to do...

Hi, I have two tables, "NewPurchaseTable" and "TheirPurchaseTable", I am viewing them side by side in subforms on a main form called "InvoiceForm". Each subform is called "OurPurchaseTableSubForm" and "TheirPurchaseTableSubform" respectively, and they are both being viewed in continuous forms...

Hi, I have built a search form where I use various checkboxes and combo boxes to filter the data that is shown on the continuous form. However I am struggling with the code for the following instance… I have a field called [Invoice ID]. I also have a check box called “MatchedFilter” . If...

Hi, I have two tables, "NewPurchaseTable" and "TheirPurchaseTable", I am viewing them side by side in subforms on a main form called "InvoiceForm". Each subform is called "OurPurchaseTableSubForm" and "TheirPurchaseTableSubform" respectively, and they are both being viewed in datasheet view...

Hi, I've tried to search for "use Like in vba" and "like in code" but I can't find anything similar. Does anyone know how to use the like function in vba? here's the statement i'm trying to write: If me.transaction_code.value = like "RC"* then me.Internet_Order.value = true any help would be...

Hi, I have a form called “Quote Entry Form” which contains a subform called “Order Details”. There is a field inside the “Order Details” subform called “Product Name” which has the “locked” property set to “Yes”. Does anyone know if there is any code that I can set to a command button to...

Hi, Im using Access 2000. Essentially I want to find out which of the entries in my master table have matching entries in my other tables, and list the ones that do. So if I have an entry in the master table for “productA”, and there are also matching entries for “productA” in tables...

Hi, I am very sorry, I’m sure this is a very basic issue but I’ve had a complete brain freeze and I can’t solve this problem. If anyone could help I would be very grateful. I have one chainsaw that I can buy from a maximum of 3 different suppliers. I have 4 tables in all – “OurTable”...