Search results

I am having problems with one computer using the front end of our database. This happens all the time and the coding on this computer and the others are all the same. At 12pm, 3pm and 5pm we want the database to update itself. If Time = "15:00:00" Then DoCmd.OpenForm "Timeupdateinfo"...

I have an make table query where i would like the users to choose a name for the table in the backup database. Dim strtbl As String strtbl = "WC26Apr" Set qdf = db.QueryDefs("Backup") strSQL = "SELECT WC16Feb.*, * " & _ "INTO & strtbl & IN & T:\data.mdb " & _...

I have a table with a yes/no value for Bob, Sue and Geoff (as these are the only users for the db. If Bob enters data i want his column in the table to say yes (-1). So to automate this process i have them find their name on a list box on a form, which then loads up the data entry form i...

After searching high and low i have still come to no answer - certain threads look promising but none have the exact solutions. I have a db set up with a table WC16Feb that holds the core of the data inputted. At the moment there are only 2 users, but this is soon to increase. There is record...

Im having a few problems with users pasting text into the textboxes and it locking the db. I have a textbox 'Ref Val' that has so that the user doesnt have to worry about getting the case wrong. But when they paste the values from elsewhere into this txtbox, the db locks. Ive told them...

I have a table with a date field eg. '02/03/2004' and have written a query to convert this into a format of just the month eg. 'March' using the following query in the field. 'Format date: Format([date],"mmmm")' This use to work on two PC's using this database, but now only works on one. Any...

Ive looked and looked for any other postings on this subject but none have answered my problem. The form 'DataCapture' has a record source of 'WC16Feb' and numerous text boxes. I also have another table 'Work_Done_TodayQR' that i want the form to look at and show the values in some text boxes...

Ive got a db that has a form that will hopefully control the queries. The value Yes needs to be in the criteria for certain columns. I would like a select button on the form to acheive this. Therefore, in the onclick event for the select button ive: If selectbutton.value = -1 then criteria =...

Have set up a db that contains the date when data was inputted such as 16/02/2004. Having this, we require a query that can grab all records between certain dates. But the problem is, we want to type in the appropriate dates in a text box on a form where a button will be pressed and a new...

Ive set up a database and all was working well until i did something that doenst allow right clicking on any of the access screens. Also from the menu bar at the top, the toolbars menu doesnt poen any more. Any ideas how to get richt clicking back?