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

Thanks pat. I didnt realise that i'd submitted the thread. I was gonna write a little more explanation rather than just demanding an answer!! Its annoying when theres just a ' missing. Its good to have a fresh eye looking over the code - i couldnt see for trying!

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 " & _...

Thanks for the prompt replies. I didnt realise when we first created the database i should design it with the future in mind. - ie more users and larger data. The db is not spilt as of yet, but that will be looked into in due course. - i wasnt aware that it would be this causeing the problem...

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

Thanks mile,

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

Solution Problem Solved: For some strange reason the Reference Library could not locate a dll file from the Windows Media Player. I re-installed WMP and re-selected the WMP from the Referenence Library and then the 'Format' command now works! Hey its a mad world out there.

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

Thanks Parker! Sometimes you need a help full prod in the right direction - Its better to learn than being spoon fed!

How? - im very new to this vba and access stuff so dont know how i would do that

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

thanks ive got that working fine now but... I forgot to mention that there are a number of columns whos values are yes/no. I tried the: Criteria = IIf(Selectbutton, "Yes", "No") and the: [Forms]![Form1]![criteria] but substituting numbers after the name, Criteria1,2 etc and Selectbutton...

yep! Im working on a test database before calling them properly!

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

I hit the wrong button! it works thanks

Thanks, Ive copied Between [Forms]![Form1]![txtbox1] And [Forms]![Form1]![txtbox2] into the criteria box but nothing happens? I just get a blank table with no data in it. Any suggestions?

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?