Search results

you need a "Subform" (read up on that), the way it works is you have the main form whose ID is synced with the subform for each record of the main. the sub form/table needs an ID (numbertype), each of the sub records can have there own ID's but lets say you have 3 publishers for song ID 1...

That's what reports are for, you need to join the header/detail as one query and use it as the control source for a report. The report will use grouping levels to control the out put as you describe it. the 2 tables are joined in the query by their related field ID... "order ID" Your output...

did you figure this out? I have some code for this, I'll post it tomorrow ( have to copy from my work laptop)

Ok I took a look at my work copy of Access 2007, and it threw me off at first..I'm still getting used to finding where Microsoft hid everything :) There's a couple of places to check, first go to "Access Options" (click round button top left). Then "Trust Center" > "macro settings" and check...

the other way you can do it is create an macro and name it AutoExec and program it to close, I have an example I'll have to dig up. then place the DB into the task sched...

What are you trying to do...the purpose for doing this?

I have never heard of anyone downgrading to Access 97, the 2 versions are somewhat different. years ago when we migrated FROM 97 to 2000 the databases had to be converted and this would sometimes cause problems...it was ugly sometimes... the only thing I could suggest is to check the...

what is supposed to happen? Are you trying to make a Hyperlink to open the file from Aceess? Or do you want to view the file in the image control?

use [Forms]![yourformname]![checkInDtAcc] Is Null in your condition. VBA can be like this... Private Sub Command83_Click() Me.txtCheckinDate.SetFocus If Me.txtCheckinDate.Text = "" Then MsgBox "You will not be able to check out an item until you have returned all" & vbNewLine & _...

Isn't that used for servers?

this guy posted in April and has not returned since ( only one post) so I don't think we can help...probably figured it out. Using the square brackets is good for simple criteria, but the better way is to use a form and use a control (textbox or combo) to enter the criteria...then place the...

DELL Latitude D830 Intel Core2 Duo T7700 (2.20GHz,4MB L2 Cache) 2 GB 667MHz - 8.5 GB/s with dual channel RAM XP-PRo SP2 ( we downgrade new purchases from Vista) Memory always makes a big difference.

to get a full compact you need to empty the tables and then compact. how many records on average are in the DB after import. For the text import are you using a specification to break up the columns?

I think your table structure is probably wrong, you should have a single column for the OPN type and one for OPT qty...this will create more records, but it can be summed using grouping in a query For what you want to do you need a query for every OPN, you won't be able to SUM OPN1 because...

hey, wow...something good actually came out of upgrading. I have a test copy of 2007 as we are upgrading this year...it takes some time to get used to.

DoCmd.TransferSpreadsheet acImport, , "TableInAccess", pathFromExcel, vbYes,"Sheet1!A1:E20" you'd have to play around with it, I haven't tried it, but it is the Range you have to work with...the sheet name alone may work also?

make sure the auto number is set to sequential and not Random

ok so you are doing it the way I suggested, could it be the file size of the image that is creating the delay? One thing to try is remove page numbering Page 1 of x and just put the page #, it is not the most desirable but I had to do this once on a report that used Charts and formatting took a...

how are your pictures stored, did you embed or use linking, it is best to not store ( increases file size) images in the database, search this site for images in Database. the method I have used in the past has images stored in a windows folder and linked via path using VB with the image...

I don't quite get why you have 2 critieria fields on 2 different forms....the Sub and Main reports should be linked by related data, the main report should be the one controlled by form criteria and the sub will return data related to the records returned by the main. Coding does not sound like...