Search results for query: *

I have a table with relational fields and one table inparticular has a section that I am currently having trouble with.. The fields are as follows: Table: UpdateCheck Fields: 'NameOfUserUpdating' 'DateUpdated' 'LastUpdated' NameOfUserUpdating will log the system name of the user editing...

Hi all and everyone... Right, I have a form that checks product selections against availability and lets you know if a product is unavailable and who to contact for specials depending on the selection... I also have a problem with emailing to a supervisor, the contents of the shown record...

I have a table like so called 'repinfo' (slightly different but relational.) postcode Rep1 Rep2 Rep3 Rep4 ======== ==== ==== ==== ==== AB10 Craig Jack Paul Jemma HX1 Phil Jezza Gavin Jake ZS3 Laa Laa Po Tinky...

I have an unbound text box in the form header that with an afterupdate event, requeries the form details. Within the body of the form, I have a calculated control that counts the number of records that are found with similar criteria to the form header control. How do I make visible the...

I am running windows 98 se, access 2000 on my database one query brings up all the customers from a table 'customer details' and lists them i.e. company_name town postcode customer_type (choice of 4 types) this is displayed as 'testcustomerdetails' subform which sits on the 'testsample'...

I am running windows 98 se, access 2000 on my database one query brings up all the customers from a table 'customer details' and lists them i.e. company_name town postcode customer_type (choice of 4 types) this is displayed as 'testcustomerdetails' subform which sits on the 'testsample'...

can anyone please explain why the following message keeps popping up on my screen when I try to save a query in MSaccess 2000: MSACCESS caused an invalid page fault in module <unknown> at 0000:1539d233. Registers: EAX=300116f8 CS=0177 EIP=1539d233 EFLGS=00010246 EBX=300116f8 SS=017f...

I am running Access 2000 on my home computer and when I try to save a query, A window pops up stating that Access has caused some form of violation and will be closed immediately (more than a little annoying!) so when I get to save point, it conks out and I have to reinput all the work over...

I am trying to write a query for a table in access, but everytime I press the save button, and occasionally when I try to just run a query, i get an error message stating that Access has caused some form of violation and will close immediately. Something to do with Kernel32. Anyone got any...

I have a database that is linked to AFD Postcode plus, so when I enter a postcode into a textbox, the rest of the address comes up for a particular area. I.E. HX1 3PA - would be Lombard Street, Halifax, W Yorks. I want my query to look at the entered postcode in that text box and extract...

I am having trouble with a combo box problem... I have a table as follows called 'Product_Allowances' ProductName Allow_Flag Allow_Brick Allow_Stone Saxon x Walling x Natural Stone x Natural Walling...

I have an unbound form (Main Form) and a sub-form (Main Form_Subform) (Main Form) supplies criteria for a query (Main Form_Query) (Main Form_Subform) is based on (Main Form_Query) Once (Main Form) last field is updated, it automatically requeries the (Main Form_Subform) and displays the data...

How would you open up a form without it appearing in the taskbar? It can be really annoying! Cheers Chyld craig@chyld.co.uk The faster rabbit lost to the slower turtle.

Right, I have a gorgeous database with one hitch. I have two forms: 'AREA' contains a textbox where a postcode value is entered i.e. HX3 or AB10 the second form 'PRODUCTS' uses the textbox from 'AREA' as criteria in a query and uses the information to extract the name of who looks after that...

I have a table called Sample_Selections It has the following fields Sample_ID Autonumber Product_Name Text Product_Type Text Product_Size Text Quantity Text I have an unbound form 'Sample_Selector' with 4 list boxes in it. each based on a query that updates the next with available...

Please help.. I am using a query with a field containing the following text: Quantity: iif([ProdType] = &quot;3 pack (concrete)&quot;, [Quantity]/3, [Quantity]) How do I use the CEILING(Number, Decimal) function to return the next number up. Thing is, if you get three items in a box and the...

I have a form with 4 list boxes on it. Once selections have been made from the list boxes, a subform uses the listbox selections as criteria and announces instructions to the user. now then, here is the good bit. I want to add the instructions to a table as a record, so that when the user...

I'd like to create my own login screen! Please help! I've seen it done where all the users details are kept on a table and then the after update of two text boxes that refer to two fields 'username' and 'password'. If your details are on the system then you will either be allowed in or be...

Right, As earlier, I have 4 comboboxes, the first one selects a product and the other 3 select variances based on that product selection, i.e. size, colour, domestic or commercial etc. Form 1 Prod Name Prod Type Prod Size Prod Colour --------- --------- ---------...

Hi All. Since I can't get the 'extract computer name' working, I'll have to settle for the old faithful login screen. How do I set up a login screen that checks to see whether the users name and password are correct then allows them to move on to the main form? I can do the codey bit but I...