Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
I have a table of sellers/creators that I use to track whether I have reviewed the current monthly product offerings for each seller/creator. I have a boolean column named 'reviewed' in the table that tracks whether I reviewed the seller/creator.
The problem I have is that at the beginning of the next month I would like to have all the 'reviewed' values cleared so that I can track whether I have reviewed the sellers/creators for the new month. I am thinking that there could be use case issues and extra complexity for an automated process to clear the 'reviewed' values. I think a button to activate the process would be a better way to do this.
Hi Derek, thank you for showing me how to copy files into my project.
Instead of copying files into my project, I would actually like to be able to link to the original file location? The scenario is: I have an existing folder structure for the files and I would like to be able to link to the existing file location(s) instead of copying them to the database folder.
Hi Derek, on the add_mini form the 'Models folder' field is the folder where the models are located for that specific record. This allows me to click the 'Model folder' file link from the 'MiniIndex' form which opens windows explorer to the folder containing the model files.
Hi Derek, is there a way to have it be a clickable link? So I can click it and open the folder?
I want the link to be something I can set for each record associated with the folder location which is different for each record.
Paul
Hi Derek, thanks for showing me how to get the data into the text boxes. I also saw the reference table for and I like how you have that organized with all the reference tables.
I am now trying to populate the file (data) control named 'filemini' on the 'mini index' form with the folder path associated with the record. I am currently unable to figure out how to get that to work. I tried many things like 'LoadFromDatabase' command and sqlexecute command. I left the sqlexecute line in the script for the project. I zipped the project (your light version) , increased the version number and uploaded it here.
Thanks,
Paul
Here is the project without the database file. I don't know if this will work for you. Let me know if it doesn't and how I can send the project to you.
Hi Derek, I tried to attach the project to this reply however, it doesn't post the reply with the file attached. The project is 64 megabytes zipped Is there another way I can send it to you?. The tablegrid is on the first form that loads and the selected row of the tablegrid populates the fields to the right of the tablegrid.
When I try to get the ID of the index item from a tablegrid that has been sorted it returns the wrong value. Is there a way that I can get the correct db ID of the grid item when the grid is sorted?
On the example databases page of MVD website, you have the Nanny agency management database download. However, it downloads the .exe file instead of a .zip file with the working MVD files so that we can learn from it.
Can you post a link to download the nanny agency management database with the .vdb and other files/folders so that we can open the database in the MVD editor and learn from how you set it up?
Posts found: 10