Search results for query: *

I'm not familiar with SQL yet, but if I need to learn it to get this done I'll have no choice. I have a table that is in horrible shape, there's no uniformity whatsoever, but it's what I have to work with, so please don't slam me for having a bad database design. I didn't create it, it's an...

Hi, A little problem, I made a table (TblKid) that has a field Contract# and a field TaskOrder#. For each Contract#, there are many TaskOrder#'s. So now I want to create a new table (TblDad) with a field Contract# with additional info such as Contractor, Point of Contact, Phone Number...

HELLO motivated ACCESS programmers! I'm not sure if this can be done, but can multiple entries be entered in a single field. Here's the scenario, a table/form that keeps track of roofing contracts. However, while many contracts correspond to fixing only the roof on one building, there are...

Hi, I've been at this problem for too long and I've tried just about everything. Here's my problem, I have a report based on a table. I have several fields in my table, but I will point out just two that I've been having problems with. One field is to record the cost (in yen currency) and the...

I'm trying to create a new report, but I'm running into a problem. The "Details" section of my report can only hold about 3 pages. I'm not looking to split up my pages using sorting and grouping, as it won't work that way. I have a page 1, page 2, page 3, page 4, and so on. Thank you for...

Is there any way of putting all the data that you have in tables and putting in a Microsoft Word Document? I already have a report template, but it's a word document. I usually copy the word document and paste it into the report (design view) then move around the fields so that they fit in the...

This may be simple or this may not be possible to do. Here's an example: I have a field called [Letter] and a field called [Number] in one table. I want to ensure that for every [Letter], there's only one [Number] and vice versa. The user may do [Letter] = A and [Number] = 1 for one record...

Hi, What is the code to position an object in a report. For example, if field1 = false then label1's left position = 5" and top position = 4". If true then the label will be positioned in another location. Is there a way of doing this? Thanks in advance.

Not sure if I should post this message under forms forum or report forum. Is there a way to get the data you have inputted into Access into an Excel spreadsheet? Generate a report in Excel format (I don't mean saving the report in Excel format)? For example, Field 1 gets inputted into cell...

I have a main form and a subform. I have a field that is required to have a value in the subform. However, when I want to create a new record on a new form, I get an error message saying that the required field in the subform cannot be null. I think the problem is, when I try to create a...

I have an unbound control in my form that calculates the subtotal for items (quantity * price = subtotal) for an order #. I'm trying to make another unbound control that calculates the entire cost of that order# (sum of subtotal = grandtotal). Is it possible to have calculations on one unbound...

Looking for a way to do this, I have a field "contractor" and another field "call number". Here's what I want to do, based on "contractor", I want "call number" to have a certain input mask. May not be possible, but would entertain any ideas. For example, this is what I want to do. If...

How do I have a form automatically input data in a field from a reference table based on what the user has inputted for other fields? For example, I have a reference table that displays the company name, the item, and the item price. My form (based on another table) requires you to input the...

I'm trying to create a simple welcome form. I have it's activate event using the following procedure: Private Sub Form_Activate() 'When the database is opened display welcome user message. 'When the timer interval is reached, this form closes and opens Switchboard If Time() < 0.5 Then...

Hi, In my form, I have a field which specifies the path of a specific file (PDF, Excel, or Word File). I'm trying to create a command button that when you click on it, it opens that specific file in the field. Is anything like that possible? Thanks in advance for your help. Mike

How's everybody doing? Got a quick question. I have a report used to print out order forms. I have a field called "status" which is used to tell whether the report has been revised or cancelled. I created two labels in my report, one called "REVISED" and the other "CANCELLED". Now my...

Hello, Is there anyway of automatically moving calendar events you receive into a separate folder? I know you can organize your inbox so that mail from certain senders go into your specified folder. I'm looking to moving all the calendar events I receive into a folder called "appointments

It's been awhile since I've visited this board since lately I've been running pretty smooth with my database thanks to this forum. I've come up with new problems however, somebody in my office asked if there's a way I can link a document to my form. Here's what I want to do, 1) Have a command...

Hi, First off, this forum has to be the best forum to go to when in need of help. Responses are always quick. Now to my question, I know you can create duplicate records, but it duplicates all the fields of your previous record. Is there a code to duplicate only certain fields of your...

Hi again, I have a main form, subform 1, and subform 2 all nested within each other. Subform 2 being the grandchild. I have a date field in subform 2 that I would like to fill out using the calendar control. Instead of having to make another calendar control within subform 2, I would like...