Search results

:):):) just feel good.....

First I would like to thank you for this site, it is really one of The Internet Tools which can be considered as a good Guide for Access Users, but in the Learning Section I couldn't find anything related to a clear explanation about VBA in access how to use the VBA to work with unbound Forms or...

Hi OakLeaf, refer to this link I hope it helps you. http://www.devhut.net/2012/07/06/vba-count-files-in-folderdirectory/

Hello IssKint, I think we need to have a save or refresh command after the update to reset the form and enable us to move to other record because when we apply the filter, it will filter the form to show the only matching record and we cannot move to the other records unless we turn the filter...

Well for me it happened once and i was lucky to have a backup and since then I am using the front end on each computer linked to the backend on the server but I have 35 users on my database and sometimes they use the same forms for the data entry

Maybe it will be good if we think about a code to set the report text boxes font without changing it from the properties of the text box, I will look for that I have never tried it before but I think it's a good idea to look for

Well I forgot the structure of your database I am replying now from my iPad I will open it tomorrow and see how I can sort it out for you

That's great berg and thanks for sharing the information so others can use it, keep the good way forward thanks again.

River as for me I told you the way you created your relationship between tables won't allow you to modify it, and also you don't need classes here there is a lot of expert people who can help and provide samples but they need to know what you would need exactly for me I my only solution is to...

Js for me I do this normally via the query itself but I need to understand the table structure can post an image here about your table structure

try =nz(sum([StockCode].[Column](3)),0) am not sure if it works because I don't know how your form is build, but still try it, then it might work.

ok open your O:/DatabaseHolder right click on the database and choose create a shortcut, then right click again on the shortcut icon and choose cut go back to your desktop right click on the desktop and choose paste, it should work.

you would need to Map a network drive to the database folder on the network from every workstation you would need to run the database on it, and then open that mapped network drive from the workstation after clicking on my computer icon, and drag the database file while holding the shift key and...

Dear Sa7ar, Here you got the database, I have changed your form Design a bit as I said to look more user friendly, what I want from you before you copy this forms to your database, kindly check it carefully and try to understand carefully how it works, a) I added four command buttons for your...

well, I am working now on your database you would have the updated one shortly, I hope you like it actually it needs some design reforming to be user friendly I will attach it back to you in here you can download it and keep it separate from your real database until you are sure what is...

Hello Sa7ar, I have downloaded your database, the size was about 55 MB that is why maybe you couldn't attach it here, but there were no data inside, so I applied the compact and repair procedure to the database and the size went down to 469 KB lots of un-needed size, i believe you need to apply...

This problem is not related to the printer as far as the text is not being cut off the margins, did you try to change the font type? Try the. Times new roman or some other similiar font

check your printer page setup to meet the report and also maybe you can reduce the printing area by using Scale option in your printer dialog box.

you can attach its ok if you click on go advanced and then on the bottom you will find another button Manage attachment from there you can attach things if you want. but now as your data are linked this way then maybe you can do the following, create a code on your FormName after Update event to...

how did you relate these tables together, in your main form how did you link the main form and the subform together. actually you can set an after update code on the FormName dropdown list, the code can initiate a recordset code to move and find the first Record in your subform holding the...