Search results

Dear Access experts, Please help... I have a table like this: Name_City XY___London YX___Washington ZZ___London SS___Chicago AA___London ... How can I achive by simple setting to get all the Cities once? (I've solved this through 'group by' but there's another function in Access to do...

Dear All, I'd like to solve the following problem. I have a table similar to this: material1_date1_qty1 material1_date2_qty2 ... material1_date9_qty9 ... materialN_dateX_qtyW I'd like to define categories for date (e.g. month) and summarize the quantities: material1_period1_qty1+2 (if...

Dear All, I have a table with several fields. Concentrating only on few fields I'd like to sort out redundant information (unnecessary records). (It is similar to using Ecxel: Data>Filter>Advanced filter>Unique records only) So, I'd like to ask for your help how can I reduce my table to...

Dear All, I'd like to ask for your precious help. I have a table of the following fields & tructure (simplified): part number; date; qty; A 01 5 A 06 12 B 03 3 B 08 29 ... My aim is to get a list of maximum qty...

I have a table similar to this table ----- ID field1 field2 field3 'ID' is the primary key but I want MS-Access to have an eye on field1-3 to avoid entering the same information into field1-3. How can I do this? (Using field1-field3 as primary keys is not desirable) Please help. Thanks in...

Dear All, I put a database on the local net, and it is not allowed to start it directly, but you can enter it through a shortcut. How can I save it like a simple database without users&password? (When the database was put on the intranet a .bak was created automatically but in the meanwhile...

Hi Guys! I made a form-subform structure and I began use it. As I put some data in the subform's fields Access started to order them by a certain field. It wasn't good because I wanted the subform's record be ordered by another field - a numbering field. (It's VB code: Me!numbering =...

Dear All, Please help me in the following: I have a VB code that automatically creates a table and then it deletes the same table, but message boxes pop up (when deleting) that isn't desirable... What can I do to eliminate those popping-up-boxes? Thank you in advance, Sz.Cs.

Dear All, I'd like to print out a report multiple times. I've found some material in this forum (the topic title was very similar to mine): DoCmd.SelectObject acReport, "DELIVERIES", True DoCmd.PrintOut acPrintAll, , , , 4 But this would have to be transformed, because my problem is the...

Dear All, Maybe my question is not too difficult. I have a form-subform structure and my aim is to number certain records of the subform. These records would contain value: 1,2,... And when changing the record on the main form, the subform's record should have the values 1,2,... again. (These...

Hi! I have got two list box on one form. The second (that lists products) depends on the first (that lists suppliers). I'd like to display the filtered list in the second list box, but it doesn't refresh 'live' only after I reopen the form. I tried to use the method available in case of combo...

Dear All, I'd like to bar (make unable to use ) a combo list on my form. The state of the combo list should depend on the true/false state of a checkbox. I don't know whether it is possible in access. I'd like to ask for your help. Thanks in advance. BR, Sz.Cs.

Hi All! I made a query that calculates the sum of from a table that contains defect types and numbers. The problem is when after the inspection there's no defect no values will be entered in the mentioned table. And running the query the result is 'NOTHING'. I tried to deal with this...

Dear All, I have another question too. It is possible to send data from a form (that doesn't base on any tables) to tables? I mean that after filling the fields of a form and then clicking a button the records of relevant tables would be set automatically. thx

Dear All, I'd like to ask you help me in the following issue (sorry, I'm a beginner): I have got a simple form - subform structure. There's a box that calculates the sum of the some fields. Those fields (which the calculation bases on) are on the subform. If I change the values of the...

Hi Guys! The following problem occured during my work: I put some fields on the main form that calculate the sum of the data entered in the fields on the subform. The problem is that when I change the value(s) in the subform's fields the calculated fields on the main form don't change. (I...

Dear All! (I sent this problem into the FORM-forum as well but maybe it belongs to here) I'd like to ask you to help me in the following. The issue is basic I think, but not for me... I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same...

Dear All! I'd like to ask you to help me in the following. The issue is basic I think, but not for me... I'd like to transfer the data entered in the fields of a form into the fields of a table (that uses the same values). This table is connected with one to one relation to the table which the...

Hi All! I d'like to ask for your help in the following issue: When I step the records on a form clicking on the arrows below I want refresh some field reacting on this event. How can I refer to this event in Visual Basic? And how can I bind the VB program to the form? (Because - as I know -...

Hi! I'd like to ask for your help in the following issue: I wanted to refresh the filtering of my combo-list on a subform according to the change of a field on the main form. With this Private Sub supplierID_AfterUpdate() Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery End...