Search results

Ah ok, well fixed that, and now it shows 1050 records however in copyofcases theres 2031 records and in dataexport73201 theres 1158 records, so its only doing an update to the one's in the current database, but how can i get it in the same query to also pull all the other records, so the 1...

ok, so if i do it like this.. UPDATE DataExport73201, CopyOfCases SET CopyOfCases.[Assigned To] = [DataExport73201].[Assigned To], CopyOfCases.[First Name] = [DataExport73201].[First Name], CopyOfCases.[Last Name] = [DataExport73201].[Last Name], CopyOfCases.[SP Begin Date] =...

they both have MC which is unique to both, as thats the identifier for the client.

ok tried a few different ways.. 1 that shows over 295488 records, of which theres 30+ records per person, that's incorrect there should only be 1 record per person UPDATE DataExport73201, CopyOfCases SET CopyOfCases.MC = DataExport73201.MC, CopyOfCases.[Assigned To] =...

The problem i'm having with it doing an update query is it doesnt update it...

Hi all, Ok this is going to probably be an easy one, however as i've not done this at all yet.. i've been having problems merging a spreadsheet with data into an already created table.. the main things in comman is the "MC", "First Name", "Last Name". I'm trying to update dates etc that are on...

ok, create a text box and in the format for it, make it a short date, that way users can pick the date for it..

ok... this is how this would be done, i'm going to show you how to do it for one and then you can work it out from there.. Private Sub combobox_AfterUpdate() Me.Start_Time = Now() End Sub what this does, is when someone updates Combobox it'll put the time into Start_Time, have a look at the...

Thanks, didnt relize it'd be done that way, as was always using the other way, and have used it like that in Excel VBA... And yes i did use the VBA.Date as thats better for me in long run..

Hi everyone, well so far so good.. and now i've got a stupid problem that i just cannot seem to get to work... basicly i want to check Textbox text528 and if the date in there has expired (anything older than today), then it'll notify me.. however weird thing is.. its notifying on dates still...

I figured out how to do it.. Was quite simple when thought about it.. on the print button leading to the next form.. i have DoCmd.OpenForm "Printformbegin", , , "ID=" & Me.ID this works excatly how i wanted it.. it pulls the information accross and is in the right record.. Thanks for the...

Hi all, Well i'm in need of some help and just cannot seem to be able to work it out, i've looked all over and cannot seem to find an answer that will work... Here's the problem I have a form called "Customer Details", on that form i have child forms, including one that has a schedule on...

Hi Speakers, i have a question as it seems you've been using this database for awhile, and i've been looking for a schedule for a long time.. and just finaly came accross this 1.. and been playing around with it.. however i have 1 question, or maybe it 2.. When you pick the start time, is...

Hi everyone, i'm a fairly good designer and creator, and have created many scripts, apps etc in the past.. However i'm now learning access 2010, would you belive i've never used access in all the time i've done programs.. lol Anyway i've been using information her to create my first database...