Search results

I have a treeview consisting of three levels. The treeview triggers a query that display sub forms relevant to the data on the three levels, all work fine. I have a new record button, this open the form in "add new record mode" and on save will it update the treeview. All works fine, except that...

I know it does not make sence, but the story is. I will be storing pictures in this databse. The database currently stores only the link and do not imbed the pictures. The problem with this is that if you put this database on a network, do you get problems when all the PC allowcate differetn...

I am using a split database, I have a table to create new datasets. My question is it posible to create a new "database" for each new dataset. For instance, I want to add a new customer, and then create a new backend database for each customer outomatically.

Good day, I have created a database that display pictures on reports. The pictures is link to the databse and not stored internally. The database is split to a front and back end. I have the macro to reconnect the back end if the position of it change. My question, is there a way to keep track...

Ok, I found the solution. Some common sense, select the graph in design view and under row source in the properties window, change the source to the Cross tab query. So I can go on with my experiments. Regards

Hi me again, Please look at the example I created. I create the radar graph from the cross-tab query. If new data is added, how can it update the graph automatically? I have used the method to extend forms or reports based on the cross tab query data, not sure how or even possible. I need to...

I requery a form when a "pop up" form closes, on the "close" command. How do I then reurn to the original selected recordset on the main form? The reocord I used to open the "pop up", it returns to the first record when I requery. Refresh is not working, since the main form needs to do a...

Try this, I use one. I make it to fit max on a small screen, and will then be the same size on a larger one. Put it on all your forms and they will overlay oneanother. Not the perfect solution but works for me. I really battled with screen sizes.

I have a main form with a tree view. There is then a sub form that is queried by clicking on the tree view, to give me some main categories. There is second sub form that is triggered by clicking on the categories, to give me some questions regarding these categories. If I click on the...

I had similar problems with my applications. My database consist of a lot of sub and even to a thrd level of sub forms. The screen resizers did not really help me. The other problem is that it really stuff the icons on your buttons. I have done what you have done, I gave all the forms a fixed...

Good day, Do someone have the code or the link to put the "All" property in the dropdown list. I need to give the users the option of selecting all records or some. I had it somewhere but can't find it. Lance

Hi Rob, Here is something, I used it but please note it is not my stuff. I cant find the it on the forum again, wanted to add the link. Play with the code to suite you. Lance

Thanks Guys, I have used you inputs. Please see the attached result. This DB will detect the USB drive letter and then give the serial number. Thanks. Lance

Thanks it help me a lot. Is there a way to "outo detect" the usb drive's drive letter? My problem is that the drive letter may vary from PC to PC, this code will not be accesable for changes, or alternative is it possible to give the drive a name and then to search for that name. Regards Lance

Good day, How can I read the serial number of a USB memory drive into a form? Regards Lance

Hi all out there. Question: I am looking in protecting my DB with the aid of a dongle. I want to use the dongles serial number (USB drive) as the security device. This number needs to be stored in code and not in a table, it is easy to break into a table and change the serial number to a known...

Ok, thanks for all the advice but I think I sorted out the problem. Look I am not a genius with VB, I am a good manipulated of code. Do not always understand what I am doing but I was able to do some amazing things already. The solution was I changed in the declarations: Dim dbsReport As...

Thanks, at least I know now I am not crazy (almost there) I do not know why it change between the two versions. Thanks

Thanks, I think it may be another problem with the code. I have downloaded some examples from the forum, and it is doing the same. What happen is, I have a report that is based on a crosstab query. It will expand depending on the info for the report. All work 100% as I need it to do, if I...

What is vague, please look at the database attached, it is not mine. I use the similar code. Open the report no problem. Convert the db to 2007 format, open the report again. You will get an error, "Type mismatch" Lance