Search results

arnelgp - thanks your code words brilliantly. :cool:

Hi Thanks everyone for the replies, I am sorry I haven't been back before to say thanks but I have been quite ill :( Anyway I am going to have a go at this today and see how I get on. I like arnelgp's idea but I had already started with the importing of the spreadsheet into a table in the...

Hi folks, sorry I wasn't sure which section to post this under so admins please feel free to move it to the correct section. I have a problem that I am sure you will all find very simple to fix. I have a table of peoples times recorded that every so often I need to add a date to one...

Yes multiple uses do use the database but everyone has exactly the same buld of pc and they are locked down so they cant fiddle with them. I will try the F11 trick now.

hi thanks for the quick reply. unfortunately as it contains MOD data even if I deleted the data I could be sacked for posting it up. A few points though, the database is a single entity and is not split into FE and BE components. The database structure has not changed for months.

Hi there, I am really pulling my hair out here. I have a database that I use and normally I dont have any problems. For some reason all of a sudden if I make any changes to the structure it errors and asks me if I want to fix the database. Entering data and running reports is fine. If I add...

The spreadsheet is very simple. It has 4 columns, the first is a text field and the other 3 are currency. The database table is only 7 fields, the first 4 fields are laid out exactly as the spreadsheet with the 3 following fields just being text that shouldnt be impacted by the update. The...

Hi, Silly question I am sure but I have tried searching and so far found nothing to help me. I have a database with a table containing customer jobs. I want to update certain fields on each record each week using data from a spreadsheet (not ideal but its the way its supplied). How do I...

Thanks for the pointer. I had just done it a slightly different way. I went into: TOOLS ACTIVE X CONTROLS I then selected register and browsed for the MSCAL.OCX file I had copied onto the pc earlier. Its all working fine now. Just wish our IT dept wouldn't deny doing things - we...

Sorry to ask such a dumb question. The machines at work have just been fiddled with by our IT dept and now the calendar control in Access is missing. IT Dept say they havent touched MS Office - liars. We are using verion 2003. Anyway when we open our database that was working normally...

thanks thats just what I needed.

Right I know how to do a For Next loop no issues. What I want to do is iterate through a loop 20 times and within that loop I want to set say picture1.visbile = true picture2.visbile = true picture3.visbile = true ..... picture20.visbile = true I would expect to be able to do...

Cheers Brian, thast exactly what I needed. The help section is like using a dictionary when you cant spell :D

Ok I know I am stupid and I must be doing something wrong. I have a text box with a value in it, I need to find out what that value is and if say its between 0 to 5 I do one action and if between 5 and 10 I do another...all the way to 100. I know how to do this in excel but cant work out...

No sorry that doesnt work, that gives me a cumulative total day by day as the week goes on. I need a total for each new day/date.

I have a report that breaks down a persons work bookings by day and within each day it sums by booking code. This is shown in the group detail. What I would like to do now is also show a sum of those booking code totals for each day in the group footer. I am going to smash my head on the...

ooo now that sounds interesting. All I am trying to do is to stop people moving to the next record by tabbing or using the page up or down keys if they havent entered data in all the required fields. Give us a clue then ;)please

cheers, it gives me a pointer. I will have a dig round for some full blown examples now you have guided me.

Ok I know I have read posts on here somewhere about having a form to enter data in that doesnt update a table at all until you tell it to save the info. I have tried searching but cant remember what to search for (now where is the smiley for being a moron?) Can anyone give me some me some...

Cheers David, at least it wasn't me going mad. I finally managed it by setting the date as dd/mmm/yyyy SQL = "UPDATE [TABLE - WR & WBS Codes] SET [TABLE - WR & WBS Codes].[DateWRADatabaseUpdated] = #" & Format(Me.[WRA Database Updated], "dd/mmm/yyyy") & "# WHERE [TABLE - WR & WBS...