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