Search results

Wayne, Thanks. Can you guide me in how and where to input the code? Do I need to have the file in Access first and right the code there somewhere? If you can explain some of the primary logic in ur code lines Ill follow it as its intended. Thanks!...

Thanks for the suggestion. I forgot to mention there are 81,000+ records! :) The number '7' may appear anywhere from column C to Column G...

Hello - I want to import a text file into a table in a database. The text file looks like this: 00001 06006025 1420 0010 Health Insurance 7 00001 06006025 1425 0010 Life Insurance 7 00001 06006025 1430 0010 Disability 7 00001 06006025 1440 0010 Profit Sharing 7 There is no consistent...

Also, is it possible to select multiple values via the pop up? For example, I want to see items assigned to more than just one specific name, perhaps two or three names. Can I specify multiple values via the pop up?

Thanks! That was simple. New question though, some of the fields in my database are entered as text, but stored as numbers. For example, I have an Assigned To name as "Manhattan Associates" entered by users in the database. But it is stores as a value of "1138297884". So, in the pop up I...

For the source query of my report, I have specified a value for the 'criteria' of one of the fields. For ex., the Assigned To field is filtered to display items assigned to a particular name. Rather than pre-define this value directly in the query, is there a way to have a pop-up appear...

That would work, but my objects are dynamic and get populated based on the query. The column headings are also automatically populated dependong on how many columns are used in the query. The # of columns and the column headings vary depending on the data in the databse... hope that makes...

I have a tabular report which uses a cross tab query as a record source to populate 'unbound' control boxes. I want to know if I can adjust the angle of the column headings so that the tex is display at an upward 45-90 degree angle. In excel, you can adjust the degrees of a cell. Is there a...

In the detail, my report displays records in the following nature: Test 1 Conditon 1 Value 1 Test 1 Condition 2 Value 1 Total Conditions for Test 1: 2 (this is fine) Test 2 Condition 1 Value 1 Test 2 Condition 1 Value 2 Test 2 Condition 1 Value 3 Total...

When trying to resolve conflicts after synchronizing with another database, Access displays the conflicting fields. Problem is that the fields that were entered as readable text are displayed as un-decipherable number strings. So I dont know what the numbers really convert to in text. In my...

I have a series of Unbound control boxes in one row. some text extend to two lines and I want everything to be centered both horizontally and vertically. Can't figure out how to vertically align the contents of the controlb boxes...

Reporting Using Crosstab Thanks Paul. I'm a bit overwhelmed with the code section. Is there a more 'wizard' type document that is cleared to understand relative to my query and field list?

We have multiple users using the same database as local copies on each of their PC's. they are entering information in specifically assigned areas and no one is overlapping in their work areas. The users then synchronize to a master database that is on the network to transfer their info. When...

I have tasks in one table that are assigned a Priority (High, Med, Low) and a Status (10, 20, 30, 40). Priority and Status are separate tables. In my report, I want a tabular output where Priority is the row heading and Status is the column heading. I have made the crosstab query properly...

Currently my data is being output like this: Process 1 Cycle 1 Function 1 Proces 1 Cycle 1 Function 2 Proces 1 Cycle 2 Function 1 Process 2 Cycle 1 Function 1 Processs 2 Cycle 1 Function 2 I want to display it like this: Process 1 Cycle 1 Function 1...

How do I get desired fields from various tables into the Field List when in the Design View of a report? Lets say I have 5 tables and I want to get certain fields from each. I am guessing I need to make aquery to filter that info. After doing that, how do I import the query fields into the...

I have information in 4 separate tables: tblProcess, tblCycle, tblFunction, tblCondition, The relationship between these tables is the following: - A process can have one or more Cycles. Each Cycle can have one or more Functions. Each Function can have one or more Conditions, etc. The...

Does anyone know how to lock a database so it can be accessed by only one person at a time? We have several users using a 'local' copy of the same database and frequently synchronizing with a network copy. We want to avoid a situation where more than one person is trying to synchronize with...

thanks! i will try that..

Lets say I have the following data: Description Status Date Complete No. One Open 1/23 No 4 Two Closed 1/23 Yes 5 Three Open 12/2 No 1 Four Open 1/3 No 2 First, I only want to display records...