Search results

I have a singe user DB running on a coal business for a number of years . The pc was an old intel and Nivida GPC. Recently the business decided to upgrade to a new PC . They chose a AMD and Radeon PC. All seemed to go well regards the change over. I noticed when testing DB on new PC when I...

I want the data entry to be at the top of my sub-form so I have used the method of using two sub-forms one with no data input allowed and just above that one the sets focus on new record entry after update and only shows one record. It works fine but for the life of me I cant get rid of the...

Hi Sorry if this has been answered before but I cant find it. Are you still able to create a DB that can be just run by a user from his PC using Access 2013 like we all did with access 2003., not using sharepoint or making it web based. I have dabbled in DB's for many years and have a charity...

Hi I dont expect this is good DB practice but even though i have a form with a memo box on it. When a new record is created a default valve is inserted in the memo box. i just want to add to the default valve not replace it. So if the default value is abcde I dont want to replace this just add...

Hi I have a form with many fields on it but I want to create a rule that if a certain check box is not ticked then at least one value must be selected from two combo boxs I have on the form. If the check box is selected this is not a requirement. Any help appreciated TP

Hi Want to create two query's for using for reports. 1. Need to see all records entered yesterday, using Date()-2 on the date entered field which seems to work sometimes but not always 2. Need to see all records entered today using Date() does not work for some reason? against the date entered...

Hi Cant understand this one. I have a report that includes the percentage symbol. It shows on all the PC's I have access to but does not show up on a remote PC that I dont have access to. It causes confusion as people are then unaware the figure is in percent. Any one got a simple answer to this?

Hi I created a report in access 2003 that gives me last months stats. The header reads "Summary of Observations submitted" I want it to read "Summary of Observations submitted Feb 2011" I have inserted a text box after submitted but end up with the date format as 17/03/2011 anyone help...

Hi I run a query on a set of data and just use >Date()-30 to give me that data over the last 30 days and thats fine, Now I want to run similar query say today 16th March that only gives me the data exactly for February or run the query in June sometime that only gives me that data for May. Dont...

I have databases at different locations not on a network. The basic design is all the same. Quite often one location will want a form or report very slightly tweaked for their location. All users at the locations only input data so the DB is quite well locked down. At the moment any changes are...

We have a DB that is used on a few of our other company locations. They are the same design but are not networked and just stand alone at the various locations. All locations use the same MS Office 2003 with same updates applied through a central networked location. I have used conditional...

Our company has inherited a DB that works fine but has not been build with a naming convention,VBA has no comments and the macros are named "macro1" etc. Tables and forms have spaces in their titles and no leading tbl or frm. I have been given the task of cleaning this all up. I have commented...

I would like to put my access 2003 DB online in read only mode, would like to be able to upload a fresh copy every week. End user just needs to be able access database and read the reports. See few options on line but very expensive I prefer much cheapness:) I have access to host websites

Hi I have a DB that we use over a network , early days yet so have left in MDB format so minor changes can easily be made as we test it. I have a log on screen that users login on and are taken to the correct form for their own department using a Macro. Today a user on his first logon got thel...

I need to create a query on a table for a report. The table includes two check boxes one called negative one called positive. You can have a record with either check box ticked or neither but the form does not allow you to have both ticked. I want a query for a report that will show each record...

I have a form with a overdue date on it , also have a overdue warning label that I have set to not visible. I want it to appear on the form when that date is now or past not sure how to achieve that?

I have a logon screen on my switchboard, user selects his name inserts his password presses command button and if its right he get access to a form. I have that working fine. His name and password are stored in the employee table along with the department hes in. What I really want to happen is...

Hi I have a form, two of the fields are Comment which is a text box and Update which is a combo box with a list of names. I am trying to prevent someone selecting his name as having updated the record but leaving the Comment field blank. Have tried validation rules on the Combo box but think I...

Hi I have a DB with some nice reports that will be used on various peoples PC's who have a an assortment of printers connected. I have reports in A3 and A4 format. The A4 ones are ok but if someone has a PC that has only a local printer that does A4 only the A3 reports will just default to A4...

Hi I have a DB that will be used on various networks and PC's. I have set it up that some departments have full access to everything and some only have access to fill in certain parts of certain forms. Done this by recreating the forms and locking various fields. This may not be too...