Recent content by BRABUS

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.