Search results

I have an invoicing database. I have a yes/no field "Invoiced", which is checked after an invoice is issued. I want to lock the other fields after this is ticked. As a minimum, I want to lock the "Invoice ID" field so costs can't end up on two invoices. I only enter data through a form, so I'm...

Could someone point me to a good site to explain how to set up a cross tab report? I found one, but I'm not quite following the code, so I'm not sure what bits of it I need to change to pick up my query. My query returns a bunch of 'static' columns (name, rate, project code), and then a bunch...

I'm using Access 2003. I have a table; pretty basic to capture the number of hours personnel work in a given week. The 'hours' field is given me the pip. Details of the field: Data Type: number Field size: long integer (although I've also tried integer and decimal) Format: standard...

Is it possible to have a make table query that prompts the user for a name? Once an invoice is submitted we create a table of the submitted data (long story why). At the moment, I have a make table query that creates "Invoice00" and then I manually change the table name to the relevant invoice...

I've probably gone about this the wrong way; but ... I've got a database that tracks our project budget and our invoiced hours to date. Each invoice covers a bracket of weeks and we are now getting variations against those weeks. To ensure that I can replicate each invoice exactly as it was...

I have a report to create a budget reconcilation with the following structure: - report header (text box with co-joined text and fields) - page header (the same as the report header but smaller format) - 2 field headers - detail - 2 field footers (for summing the fields) - page footer (date &...

Unfortunately, I wasn't the bunny that got to try and run it on the client's machine :-) I have a call into someone to find exactly what happens at their end. My understanding is, though, that it simply doesn't run. Will clarify soon.

I have a database designed entirely in Access 2003. Our computers were recently upgraded to Office 2007, but still running Access 2003. The database works fine on my machine. But the client, who runs 2003, can not use it any more. Obviously, this is a bit of a problem. We've gone through...

I have a table of corporation names. This is three fields - CorpID; CorpName; CorpAbbr (ie Record #1 is "Environmental Protection Agency", EPA). The data is used in combination with other tables (eg against report titles as a the corp owner). Where this data is available to users on forms...

I'm creating a database to capture various documents (hard copy books, electronic downloads, journal references). I started this project some time ago. I've been working on a super large database and now have considerable more Access experience, so I'm trying to make the existing data for...

I have a monster of a database, over 100 of each element. Now that we're approaching design of this thing being finished (please God) I'm doing some housekeeping. This involves three steps: 1. Making a note in each element's properties as to its purpose. 2. Working out what is actually...

In a report, how do I concatenate a combo and text field? My example: In Table 1 I have a field "Name", which is look up bound to column 1 but showing column 2 of Table 2. I also have a free entry date field "Date". I like a single item on my report "[Name], [Date]". Whenever I've...

Anyone? Boxes growing without those next to them growing is making various sections of my report look very untidy.

Can I link the size of a field in a report to a second field? I have a combo box with conditional formatting. It shows no text, but depending on the response entered in the form it shows a different colour (red, orange green). It sits in a table (as in Word table, not Acess table) like...

I have a report that is basically comprised of a dozen or more subreports. If there's no data in a sub-report it doesn't show in the report at all. Ideally, I'd like the structure of the sub-report to show, just with no data. Is this an easy fix?

I'm having some trouble exporting reports and wonder if there any 'neat tricks'? The overview is I have a master report with about a dozen sub-reports. The client uses the information of some of those sub-reports in other reports created outside the database. Some of the data in the...

I have some code on a form that requires a password to turn on some other boxes and things. If InputBox("Please enter password to continue", "Password Input") <> "aaa" Then MsgBox "Wrong password entered. Operation aborted", vbCritical Else do this that and something else I've...

I am currently writing both a user guide and a technical manual for our monster database. The user guide relies extensively on screen dumps as its a step-by-step "this is how you do it" deal. I've been told to make the technical manual more "geek level". I'm wondering if there's any standard...

I have been given the task of writing a technical manual for the monster database we have designed. This thing has 70 or 80 tables and all the related queries, forms and reports. It's huge. Is it possible to export a list of all the structural contents. Part of my task to define what each...

I could scream! :eek: In their infinite wisdom, our IT people have rolled out an Office 2007 upgrade. Access is not standard, and therefore is left as 2003. The database - which I am presenting in a 3 hour workshop to the client TOMORROW - is 2003. One of the designers was "upgraded" :( to...