Search results for query: *

Hi I need to find a solution that i can use the same icon to start access97 and 2000 (XP, 2003??) I tried to create something like an router that will recognise the files but i failed. can anyone help? Thank you in advance nadir

Hello I need some help with this issue. I have a table with formulations looking like this: name, code, item1, item2,....item qty1, itemqty2,..... i need to be able to change item2 and the coresponding itemqty2. Also i nne to do a calculations wit a factor for itemqty2. so instead item2 i need...

Hi I ahve a problem with a subform. The design: Form1 cbo to choose item Order button Subform one option to order subhform 2 show the order all are conected through the cbo value. click on order, pop-up shows with info, choose Qty and close. at this point the sub2 shoul be populated with data...

Hi I have a problem that keeps me up the last 2 days. I would like to e-mail 3 diff people (To, CC, BCC) a report cretaed on the basis of a form. the 3 e-mail adresses are populated by choice of the operator. How can i do that. i tried many of the choices available here...but still nothing. I am...

Hi I built the autonumber using various help, it works on my pd, but when i place it into the BE, i get an error msg. Here is the module: Public Function acbGetCounter() As Long ' Get a value from the counters table and ' increment it Dim db As DAO.Database Dim rst As...

Hi I have a system that works as e-docket (order) system. I have at max 7 users on at the same time. I tried my best to cretate a multi user system. I have my be on the server, and the fe on the desktops of users. My ID number is =Nz(Dmax...) But ever so often (if it can it will go wrong) i get...

Hi For the last few hours i am trying to figure this out... i have a form and on the form a field quantity, the same in the table inv_process. i need to have the users update this value, click or whatever. i mean, they will see two textboxes, one shows the current value, the second is for the...

Hi I ghave a form (tbl_inv) that has a subform (tbl_code_querry) that are joined through a field called code. The subform is a continuos form because there can be many items under same code but different manufacturer. My problem is how to update the subform using the order items. (ACC97, OS XP)...

hi how can i save (get) the autonumber last, after all other needed data is filled? thx

Hi I have a form with a subform, where the two are not conected at all. The subform is a table with static data, and the forms table is dynamic. how can i create a link and have the subform main subject saved ion the form table for further use and display. To elaborate: the subform contains all...

How can I make sure? That users cannot duplicate or delete my AutoNumber’s ( =Dmax(“field”, “table”)+1) At this moment, if in a continuos form (subform)by clicking on the number you increase the number (unfortunately, the trigger for the change is On field Enter). How can I change this? I...

Table, Query, Form question I have a table with ID numbers that are written out already. Numeric sequence. I need a procedure that will take the next available number and display it on my form, as well as write it in a different table. The number has to be deleted from the first table. Also if...

hi i have a problem that keeps me going fo rthe last 2 days. i have a continuos form, that i fill with data for manufacture formulas, and all the numbers need to be generated at that point. my problem is that this is a subform, so it does not get refreshed, and when i use dmax...

hi i have a problem that keeps me going fo rthe last 2 days. i have a continuos form, that i fill with data for manufacture formulas, and all the numbers need to be generated at that point. my problem is that this is a subform, so it does not get refreshed, and when i use dmax...

hi i have a problem that keeps me going fo rthe last 2 days. i have a continuos form, that i fill with data for manufacture formulas, and all the numbers need to be generated at that point. my problem is that this is a subform, so it does not get refreshed, and when i use dmax...

Hi I have a problem with the an ID field that is my sequential ID number field (=DMAx("DOcketID", "docket")+1 and with a set of combo's where i choose my customers, from a different table, but saved in table where the docket is too. What asstually happens is that my docketID...