Search results

Hi guys Am new in SQL server. i use SQL server 2003 ans am trying to retieve the last three orders made. Can you please help me with my Select statement so that it will only select the last three coz @ the moment it selects everything CODE: SELECT dbo.Invoice.InvoiceNo...

Good day I'm trying to insert/ attach data from some website. in this case weather from weathersa.com. Some1 told me that has to do with RSS feeds but am lost as to how i can go about doing it. Plsssssssssss help Noks

i've tried yo way which help coz it turned out that i had to fix the table first. but. here's ma code insertHistory = "INSERT INTO History (SELECT almost.customercode" insertHistory = insertHistory & " FROM almost, History)" insertHistory = insertHistory & " WHERE me.Customercode =...

Actually i do need it to keep the history. the primary for tbl2 is customercode_date wich is the combination of customercode & date As for appending this is what am trying to do with dis code insertHistory = "INSERT INTO history ( SELECT strAll.* FROM strAll )"

Hi guys Can you please help me with the syntax to save data within a form using tblA to tblB (whicheva changes i make on the form, i want saved on both tables) i've tried this whenever i click the done command but it's not workin :rolleyes: CODE: DoCmd.RunCommand acCmdSaveRecord Dim strAll...

not 2 long as the amount of time... as in the process... i wanna take out the temp tables. I append to the temp tables cos the results r usually for certain accounts the on the other tables i do joins whereby i enter the other customers which contain nothing so that they'll display 0 value, den...

Hi guys. Wheneva i load a certain screen i wanna read off a table and display the results in textbox (preferably a lable but it seems like that's not allowed - i know in VB6 it's possible) Curently i use queries to do that, i append my data to some temp tables then send it to the original...

Thank you It actually worked when u sed this code stLinkCriteria = "[Customercode] = '" & Me![CombCustCode] & "' And [unique_id] = " & Me![combunique_ID] it turns out it's coz the unique number is not text i had to take out the quotes :D

I'm trying to open another form using a criteria. When i use 1 criteria all's well but when i use 2 the form doesn't wanna open. I get the following error msg The open from action was cancelled Here's my code: stLinkCriteria = "([Customercode] = '" & Me![CombCustCode] & "' AND [unique_id] =...

Hi dealwi8me, did dis actually work coz hav been tryin 2 do d same thing but i keep gettin type mismatch (error) & it doesn't specify exaclty where's d error Pls c ma code stLinkCriteria = "Customercode = " & Me![CombCustCode] And "customername = " & Me![CombCustName]

I'm trying to type properly but am so not used to it that most of the time i forget, to make sure i usually ask someone to check whateva report i've made to verify that all's well

Nice and short... Thanks

Hi guys. i want a flag 2 go off within 5 days of doin a certain task (ie accepind a new clients' details & send some1 a mail aftawards, make an order via mail) Reason bein i wanna do a follow up and c if d requeted task has been attended to Ma code: Option Compare Database Function...

Hi guys am not sure if i got dis in d correct forum (forgive me if not) Just wanted 2 know what's d diff btwn a thread & a post (if d's any) Noks

Now dat sounds much beta

Thanks Denni 4 respondin Ol i had 2 do was not 2 close d login form Cheez

It gets closed... Could dat b d problem?

I'm trying to display the logged in user in each and every 1 of my screens but my prog keeps crashin, claiming that it doesn't know d form am referencing (even though d form does exist) MAybe am doin somethin wrong... pls help My code: Me.Text88 = [Forms]![login]![txtUserName] Could it have...

hi guys (Am not sure if this is the correct platform for dis Question) Is there a way of retrievin a screen history 2 see what the conversation was about I have created this application for my users (which work perfectly fine) Now they wanna keep track of the conversation as in if they click...

I think it would b best if a person can b able 2 specify if an issue / thread has been solved so that people can search directly the resolved 1s and if they can't find an answer then search d forum... Ne way dat's ma 2cents worth opinion... Thanks again Cheez 4 now :-)