Search results

  1. N

    Displaying the 5 last records used

    Is there a way i can display the 5 last storenames i've saved? Like the myrecent document in ms office Pls kindly help Regards Noks
  2. N

    Displaying a tab after saving

    Hi I wanna display the first tab after saving. Can you please let know how do i go about doing that Regards Noks
  3. N

    Displaying only the dates that exist for the specific customer (screen)

    Hi Can you please help me with my code. I'm trying to display only the dates that are available in the history table fo the customer displayed in the screen & it's not working Here's my code: SELECT DISTINCT date FROM Sasol_campaign_history WHERE sasol_master_campaign.[store...
  4. N

    applying certeain commands when certain conditions are met

    Hi I want to execute certain actions (ie. select an option and deselect certain options) when i click next record on my tab. Where should i put my coding coz if i put it on form load it's only executed when i load the form but i want it to be executed everytime i go to the next record Regards Noks
  5. N

    Inserting data into word document

    Hi guys Is it possible to insert data into a word document. ie whenever a user takes a certain action - data should be added into the word document (which will b in a shared folder) If so can u pls kindly assist Noks
  6. N

    BI / Datawharehousing

    Hi guys Am not sure if i've posted this issue in the right forum. If not pls let me know which 1 is. I'm interested in workin in Datawharehousing or BI, so i was wondering how do i go about that. (As in which courses can i take and which books can i use). I am currently a developer. Pls...
  7. N

    selecting the last 3 orders made

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

    RSS Feeds / inserting graph from the web to my form

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

    saving data from a form using tableA to tableB

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

    Reading off a table and displaying the result in a textbox

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

    open form action canceled

    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] =...
  12. N

    Setting up a flag/ follow up

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

    Difference between Post and thread

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

    Login data

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

    Screen / Call history

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

    Mandatory / Required field

    Hi guys I'm trying to force the user to enter the Customername, Contact person and (tel or cell nbr). Everything's fine for the customer and contact person as i hav made the required fields on the table. The problem is i the user doesn't enter the customername or contact person it complains...
  17. N

    Access Link / Shortcut

    Hi guys Is it possible to make a link or somthin in some1's desktop (user) so that they can jut click on it and get connected to my Ms Access application. Is it also possible 2 just display d form (i don't want the user 2 b able 2 see nor access my tables, queries and code) Thanks
  18. N

    Loading searched data in a form

    Hi guys, am new in developing with Ms Access I use Access 2003. I've got a search screen which is working perfectly fine. now i wanna load the data that's = to the search criteria but i want it in another (seperate) screen Can u please kindly help as to how can i do that 1st screen (Search...
Back
Top Bottom