Search results

I'm hoping someone can help me figure out a problem I need to solve. At our company, plans are reviewed every 3 years after a plan is created, i.e. a plan created in 2011 would be reviewed in 2014. Most plans were created in either 2010, 2011, or 2012 however new plans can be created, albeit...

I'm trying to figure out a problem I'm having with DLookup, and I think I've hit the limit of my abilities. I've created a form (frmMain) that is used to enter student records. What I'm wanting to do is to check if a student already exists in the database. Rather than wait until the whole...

I need to join two tables, TableA and TableB. These were originally Excel spreadsheets which are being converted to Access for some data massaging, and then going back to Excel. TableA has fields: Stock_Item, Price, Description, etc. With sample data: Q00001, 10.00, Blue Ball Q00002, 15.00...

This is either very simple or very complex, I haven't figured out which yet. I need to know the number of tables in my database and from each table I need to know how many records are in each table. Ordinarily I would just count the number of tables then open each one up to get the number of...

Not sure if this is a Table question, a General question or what exactly. I'm working with a lot of records (millions of them). Assuming each record/field contains identical data, I'm wondering which would result in a larger overall DB size: - 10 million records, 4 fields each - 30 million...

I have a table that I need to query that looks something like this: ID Type Product ID 123 Health 323 123 Health 424 123 Dental 424 124 Health 323 125 Dental 323 What I need to see is something like this: ID Type Product ID 123...

Not sure if what I want to do is possible, or at least possible the way things are set up. I have a massive table - c. 6 million rows. It contains data along these lines: Plan#, Item, Price, Description, Colour, Value, Location, etc. The primary key would be Plan# + Item. Each Plan# has...

I have a question and I'll apologize in advance because it may or may not really be an Access question. I have a large ASCII spreadsheet that I have imported into Access. It has 4 columns, and has these headings: CodeID, Group, Division, Account. Many Division and Account combinations can...

I have a table set up like this: Client,ServiceDate,Service1,Service2...Service7,Msg01,Msg02...Msg20 The Service fields may or may not have values under each, depending on the number of services performed for the client, and they are always entered consecutively (i.e. Service1 will always have...

This is either quite simple or quite difficult, but I'm at a loss to figure out which! I have a simple table with 4 fields. A simple example with sample data: FIELD1,FIELD2, FIELD3, FIELD4 Brazil, Dog, Fido, 12 years Brazil, Cat, Boots, 3 years Brazil, Cat, Socks, 5 years Canada, Cat, Boots...

I have three sub forms on a main form. Each of the sub forms is attached to its own query and returns the a field of text from the record when a certain field, PROCEDURE, equals a specified value. (Each subform is looking for a specific value.) Everything is working great, unless there is...

Hopefully this is in the right forum - the issue is pretty equally queries and forms... I have a table set up as follows: POLICY, DIVISION, PROCEDURE, FREQUENCY, ISSUE. There can be multiple divisions with multiple procedures for the same policy but only one frequency and issue per procedure...

Okay, first I apologize for the confusing subject line, but I don't know how to better describe my problem, which hopefully is a simple one. I have two tables, BADCLASS and TERMINATED. BADCLASS shows a list of policies that have a problem. TERMINATED shows a list of policies that have been...

Hello, This is an extract from a table which I am trying to run a query against: (Pardon the poor formatting... life just isn't simple today!) ID Policy Lives 1000 123456 500 1000 123456 500 1500 453451 73 1750 453472 45 2000 123456 500 2000 123456 500 (note, repeated) 2000 456714 1000...

I have 2 tables set up as follows: TableA Procedure, Edit1, Edit2, Edit3, Edit4 e.g. Cleaning,00801,00304,00000,00000 Filing,00304,00000,00000,00000 TableB Edit, Description e.g. 00801,This procedure is eligible once per quarter 00304,This procedure is not covered under your plan What I want...

I have a continuous form which users update periodically. Depending on the value of one of the fields, NOTES, other fields (FIELD_1, FIELD_2 and FIELD_3) should not accept data. I have toyed with the idea of making the field invisible if NOTES is equal to a certain value. On continous forms...

I have a form on which users enter data. The text boxes are labelled F1, F2, F3, etc. and match the table name (box F1=field F1, etc). On text box F7, users are to enter a client ID and it must be exact - no spaces are allowed. I have set up that box with =Trim([F7]) on the AfterUpdate...

Is it possible to (painlessly) allow users to have full control over their cursor keys? I have a few users who are very used to Excel and find it awkward having to shift between the mouse and the keyboard. They would like to be able to use the up and down arrow keys and have the cursor move up...

I have several forms which use some fairly complex formulae to produce some results numbers. These forms feed one further form which uses the numbers generated in the first form. The user runs a macro which opens the first forms and then the last form. The problem is that the first forms are...

Hopefully this is a simple one for a Friday... I have a query as follows: SELECT [ENTER QUARTER (Q1, Q2, Q3 or Q4)] AS [Working Quarter], * FROM [BPO London] WHERE [Quarter] = [ENTER QUARTER (Q1, Q2, Q3 or Q4)]; I have a form that is based on this query. When the form opens it displays...