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 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...

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...

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...

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

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...

Hi All out there, I discoverd a problem with my reports that is running off a cross tab query. It is working fine, until I covert the database to 2007 format. I then get a "type misatch" error. I have downloaded some of the samples off the forum, and they also do it. Do I miss something...

Hi Can someone please tel me why do I get a run time error (only on the reports) if I convert my database to a .accdr database. If I change it back to .accdb it works fine. Regards Lance

Good day all out there, A question, I want to create database to do Audits with. The idea is to be able to have the database stored on a server or local PC and then to download an audit to a mobile device with windows mobile. On completion of the Audit I want to download the new data back unto...

Hi everyone I need to sort out the screen size of my application. Some forms will have up to three sub forms. I can't get the scree re-sizers to work. Is it possbile to get a fix screen size setup for a 14' screen, and then put the application in the centre of the screen when moving to a...

Good day all out there I tried the screen resizers to adjust my application between different screen sizes, not with great success. I have like up to three subforms on some forms that create havock. Is it posible to set a fixed screen size and then put it in the centre of the screen...

I need help again, How can I prevent the error "can't go to next record" I have a DB where one can scan through the records with command buttons. I do not use the "standard" record selectors of the form. Any suggestions Lance:confused:

Good day all. I have a database that consist of a task list and the time spent on these tasks. Two things, what is the best method to use as the input for the time duration of the task, it can vary from min or hours. I then need to total these hours. It does not seems like the normal date time...

Please help I had think myself into a corner with someting simple. What is the format for a statement where two fields need to be equal to a value. If me.x = "1" and me.y = "2" then me.z = "whatever" end if What should this statment actually look like Thanks

Please give advice How can I prevent someone to export tables & queries. If I open a blank database, I can import all my tables and queries into with the "get external data" command. How can I block this. I did setup the permissions and does not seems to work. Thanks

Please help, How can I present the data of cross tab query in a report. The amount of column headings can change depending on amount of data. How can this be presented in a report, due to fact that the headings can change. Thanks

Please help I need to list tasks in a sequential numbers. Meaning that the task numbers must follow one another (not the Autonumber PK). I can do this with Dmax nz function. I need the system to be able to auto update these numbers if record is added or deleted. It is not necessarry to store...