Recent content by pinkdatabase

Thanks for this Have been away Not sure what the code is doing with respect to virtual deleting Can you clarify?:confused:

Thanks Dave Didn't know you could hide columns. Now I see that it is a function in Access

Sorry All I have seen that the designer has dragged the edges of the missing fields together so they are not displayed. Not sure if they knew about Select Queries.

I have inherited a database developed in Access 2007. I am not too familiar with 2007 yet. There are a number of tables in the database that have the same situation in which when you look at the design of the table there are 20 fields indicated. When you look at the datasheet view there are only...

Thank you Forms(stringvariable)!IsDeleted Worked a treat

I was trying to do this outside the form in a Module and the problem is to reference and update a checkbox on the "current" form Getting the name of the form no matter what form is open Forms!srtCurrentName!IsDeleted does not work Is there some way to do this outside the form BTW I didn't...

I am trying to set up a system where by when a user wants to delete a record it is not deleted as such but flagged as deleted by recording -1 in the table's IsDeleted field. I do not want important information to be totally lost to the database To do this I have IsDeleted Yes/No in every...

Another way I was developing is to read the machine name and system user name and rely back to those two parameters to identify my user. But this meant it would be difficult for me to use an Access query to identify my user without a lot of code. So with the fact that deployed fe is faster then...

Thanks All Have decided to deploy the fe to each of the workstations and will have a look at the tools for deployment you mentioned Greg

Thanks David I was hoping not to have to do that as there are issues with deployment but maybe it is the best solution as I believe it will speed the application up as well over the network Greg

Also you would put the DistrictName in the tblCity table You can have as many Villages in a city as you like rather than be restricted to the 5

You essentially have a bunch of Villages linked to Cities in a one to many relationship. Each Village has a bunch of answers to your questions (ie FamilyNo_PreConflict_Native, FamilyNo_PostConflict_Native, etc) So you will have two Tables tblCities (CityID, CityName, CityInformation, etc) and...

I have a MS Access 2003 database which is shared over a network. I have split the database to an application MDE file and a data MDB file (backend) each sitting on the server. There is only one version of the application mde which is located on the server. The is no application or data on the...