Search results

Hello all, I have 3 Access databases running on a server. I've just started to get this message "dmDriverExtra too large" when I try to create a new report or query. Rest of the time the databases work fine. Any ideas ? Thanks Stu

Hello all, Hope I can explain this well… I’ve got 2 tables, one with customer details and one with job details. On the job form I want to be able to select an account number from a list box and then automatically display the appropriate customer details Customer table has fields called...

Thanks gents, I think I'm almost there. I've set Data Entry property to Yes and now when the form opens its only displaying data in two field, both of which are set to a particular value by default and dont affect the way the form works. As soon as I click the filter by form button the drop...

Thanks Adam. I've tried creating a blank form but am struggling as a few of my fields are set where they have to contain data. Where would I add the DATAENTRY=TRUE bit in your reply? In the button properties I can see On-Click [Event Procedure] which takes me to this bit of SQL... Private...

Hello everyone, I've got a similar posting to the gent that asked about clearing a form. I want to be able to display a form and allow the users to select Filter by Form to analyise data. I've created a form with the fields I want that uses my main database table as a record source. When I...

Two questions in one night - I'm struggling today :p I've got a form that opens to display records. Within the form is a field called c_exists that either contains the value Yes or No. I want a message to display on the screen that follows this basic logic... iif([c_exists]="Yes","Complaint...

Thats got it - Simple when you know how. thanks :D

Hello all, Another one for you. I've got a crosstab query running with depots on the left and months of the year across the top. Row totals are easy but I want to add column totals at the bottom of the report. I've tried adding a field in the page footer and the report footer and declaring...

Thanks for the replies. Firstly I havent split the database, its just 1 file. I assume your going to shout now and tell me I'm an idiot - but can you explain the advantages of splitting the database. I have tried opening the record locking file in notepad but all that returns is the server name...

Hello all, I have a couple of Access databases running on the network at work. A persistent problem I have is wanting to make a change but because people are logged on I cant. Is there a way I can identify who is logged onto a database ? Thanks Stu:D

Thanks for the replies. I could also add a hyperlink on the form to allow the user to navigate to where the letters are stored... Again, just thinking outside the box if I was really clever I could transfer a unique record number from the complaint to a SQL script that searches for the...

Hello all, I'm just about to start a new project which will include the building of a new Access database at work to help manage the complaints processes. I've been asked if it would be possible for an image to be embedded into a form. For example, a complaint is received and is scanned and...

I'm with you now. I actually want to extract the month so that I can build a crosstab query that displays the month of date raised on the left, a status field at the top and a cost field as the data. All fields exist within the same table and are called. -date raised -status -cost I've build...

Thanks for the replies. Both fields "date raised" and "month" are stored within the same table on the database. Stu

Hello all, I have a field called "date raised" in a database. When a particular form opens I want a field called month to be set to the month number of the date raised field. I've gone into the form properties box, On Load, event procedure and entered this... Month = Month ([date...

Hello again, Finally got some time today to check the solution offered and put this into the criteria field Like [Please enter client name] Which works a treat when I run the query, entering * brings up all data. But (And you knew there was a but coming!!!) - I have a crosstab that runs...

Thats great then. I'll have a play when I get to work tomorrow and let you know how I get on. Thanks for your help

Thanks for the quick reply. I've just had a quick look at the "Like" clause on the internet and wanted to check my understanding.. If I make a change to the criteria in the client field from =[Please enter client name] to Like [Please enter client name]. Users can enter Fred Smith to see the...

Hello all, i've got a query running on a database that asks for a user input when its run in the "Client" field. Users can enter details and the query extracts data for that specific client. However, some users want to be able to extract data for all clients. How do I tell Access to extract...

Brilliant :) works perfectly. Thanks for your help Stu