Recent content by Spelthorne1

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!