Search results

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

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

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

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

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

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

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

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

Ok this is probably childsplay to most of you. I currently have a form that I use to enter data to a table called FRED. On this form I have a buttom that sets the date and time value on the table called FRED to the current date and time using NOW(). That works fine. Now at the same time...

Ok I have this code to (try to) pull some info out of a table depending on the value in my current form. I am just using the message box as a quick way to display my results for the moment. varx = DLookup("[Folder Location]", "[TABLE - WR & WBS Codes]", "Criteria = '" & Forms![ZZZZZ test...

I have a form [FORM - ENTER DATA] which I use to enter data about orders. This is stored in [TABLE - Enter Data]. As each entry is created it uses a combo box to pull an order number from a table called [TABLE - WR & WBS Codes] but stores this in [TABLE - ENTER Data]. [TABLE - WR & WBS...

Hi I have created a query that produces exactly what I want and from that I then run a report. This is great until I then want to group the report by date. The table that the info comes from has the date created by the now() command so its in the dd/mm/yyyy hh:mm:ss If I group on the date...

Hi sorry for being a newbie and asking dumb questions but i have done my best to trawl the site using the search features but it turned up nothing. Anyway.....I am trying to impport data into access and append it all to one table. Currently the data is in MHTML format (dont shout at me yet -...