Search results

I have a db (unsplit with approx 10 users) it keeps corrupting but I am looking into why. When it does corrupt sometimes I seem to lose data and it messes with the table relationships (ie it deletes some of them) When I re enter the relationship and try to enforce the ref integrity I am unable...

Arrrrggghhh My database has just gone mad. 90% of the records from the main table have vanished. All the related records in other tables seem to be still there however. the relation is based on a contract number starting 0001 - up to 6500. All the ones starting with a 0 are still there but the...

I have a simple "orders" database. A main order form with a subform. the subform lists the product with a combo box and then enters the unit price from the same table automatically. My problem is that a product can have 9 prices dependant on price band. (Unfortunately there is no common...

I have set up a form with two combo boxes - the first is a "category" drop down the second combo box is on a filtered query which only selects the criteria of a particular category. Ie first combo select "fruit" as the category, second then only lists apples, pears etc (using [Forms]![Order...

I am just about to start a new project (not that i have enough on the go at the moment), but before I get stuck in I was wondering if anyone could give me ideas on which way to go. The project will be a quotation system - I will base it on the "Order entry" template in access - (albeit...

I've tried and I am sure it is simple......I need a message box to appear when a duplicate entry (tel no) is attempted to be entered onto a form and to proceed if OK I have put the following in the before update on the field property on the form If Not IsNull(DLookup("[Tel No]", "Lead Slip"...

I am attempting a new project to add to an existing database and some initial guidance would be appeciated. I am trying to import orders raised from a seperate "design" program. The program saves the order in note pad. I have played around with the "get external data" wizard and seems to be...

I have searched the forum and my problem does not appear to be uncommon - but there appears to be no definitive solution. Any futher help would be appreciated. The problem is on opening the message "the database needs to be repaired ....you may have quit access whilst a db was open etc."...

I have not visited this forum for a while as everything has been OK. However, I have just looked into one of my databases and all of the tables and queries have gone missing! the data is still there and everything appear to function OK, but the tables are no longer listed. When attempting to...

Thanks It's making more sense already.....a bit of playing around / experimenting and I should get there.

Good Afternoon all I have a report with a formula as below =(DSum("[PriceGiven]","Results 1","[Sales Finance] = 'FI'"))+(DSum("[PriceGiven]","Results 1","[Sales Finance] = 'FD'")) This is basically picking the data from the query Results 1 and adding the price given up where the result of FI...

What started out 18 months ago as a small project to get my head around Access has now turned into the "lifeblood" of the business. The systems in place all revolve around a central Access database (which I continually add to) without which the Company would obviously struggle. The system is...

I have a form which I have tried to make pretty much foolproof in terms of data entry. On closing the form it checks for fields with null values and does not allow it to close unless an entry is made. This is great.....but.......people want to be able to quit the form without saving any of the...

Strange.... I have a continuous form set up - basically one long list of records. The form has a custom toolbar with the A-Z, Z-A, Filter by selection (the funnel) and remove filter buttons. It all seems to work fine. Ie sorting records into date order. Click on "a supplier" and it selects...

I have a "purchase order" form which is based on related tables and including a subform for products. A purchase order report is based on the form with a preview button on the from. It all works fine if all the fields on the form are completed. However if fields on the form are left blank...

OK ....I am sure this one is very simple but here we go I have a default date set up on a form as now() so each time a new record is entered it brings up todays date. Tt is set to short date xx/xx/xx with an input mask My problem is that elsewhere I am running a summary form which includes...

I have a report prepared from a wizard from a form (and amended) The form (purchase order) has a combo box "ContractNo" picking up info from a SQL query (is this the right terminology) I have another field on the form "Customer Name" linked to the combo - [ContractNo].[Column](1). this works...

I am struggling getting the exact code for my If function, any help would be appreciated..... I have a purchase order form linked to a main customer table - so every order has to have an associated customer. The Customer No on the order is a combo box linked to the Customer table with a "Not...

I have created a report using the wizard based on two tables - Purchase Order and Purchase Order Detail. The sections of the report are the normal headers / footers but also a PurchaseOrder_PurchaseOrderID header, which I assume is something to do with a subreport being set up. I want to add a...

I have one field in a from that I don't really want all users to see. Without going down the security / password route has anyone got any neat tricks on hiding the field and only displaying if you know how. Ie a hidden button or something. I did think of just putting it right at the bottom of...