Search results for query: *

Your awesome, thanks.

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...

I'm not trying to make a many to many relationship actually. For example, A1, A2, A3, A4, etc... B1, B2, B3, B4 etc... "A" is the contract number and "1" is the Task Order. Just want to make sure that the person does not input a duplicate task order for the same contract number. Damn, I'm...

Sorry, made it a bit confusing, let me use the real names of the tables. We have contracts here called IDIQ contracts usually with a number in this type of format: N62836-11235. Now IDIQ contracts have task orders. N62836-00001 can have Task Orders 1,2,3,4,5,6,etc... Now N62836-00002 can...

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...

PHV, Thank you for the reply, but I don't know what you mean by foreign keys. Here's a more detailed explanation of my situation, any help with designing my database is greatly appreciated. I have tblBuilding which contains building data (Building#, Size, Age, etc...). I have tblContract...

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...

Thanks lupins46! Your suggestion worked, why didn't I think of that? Now I can rest in peace.

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...

Ok, maybe I'm confusing myself with my wording. What you said in the latter is what I want to do. If there's an A1, then a B1, C1, D1, etc... would be feasible still. And if there's an A1, then A2, A3, A4, and etc... would be feasible as well. If there's only one letter to a number, that...

Forgive my lack of knowledge, but how do I go about doing that?

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...

Thanks! Anyway of setting a prefix before the number?

Presently, I have no data, I'm still building. It would be nice if the system does generate the next number. Makes my database that much more user friendly. Thanks.