Search results

Hi I now need to import a CSV file into my database on a daily basis. I have no experience of an import routene, does anybody have any pointers or do's & dont's, before I begin to try to fathom it out... Thanks in advance.

Thankyou, I will try it.

Hi, I need to capture data from fields in a form and write it to a table, however, the form is bound to a different table where it exracts/populates most of the fields. my command button concatenates information in to a single string which writes the values to a [Notes] field against a...

thank you OB1 .....:)

sussed it... something stupid!!! location table was a 'Number' field ProjectLocation was a 'Text' field. feel really dumb now....:(

Colorado Rockies eh!, big mountains - lots of snow!!! Thanks for the reply, but i just cannot get it to work... tblProjects ProjectID ProjectName ProjectRef ProjectLocation tblLocation LocationID LocationName above is an exapmle of the fields: which ones do i join? I get a mismatch if i...

Hi, I think there is a very simple answer to this but it is giving me brain ache!! I have a form which displays or edits 'projects', this form is bound to the projects table each project record is assigned a location, that location is selected from a combo box. When the Location is selected...

set the focus to the next appropriate control: someothercontrol.setfocus

forget the macro... in the on click event procedure of your command button put in the following code: *DateTime = Date & " ~ " & Time substitute *DateTime for the name of the 'datetime field' in your table, then format the textbox to create the correct LongDate/ShortDate etc.... use any...

Thank you both for your quick and simple replies... After playing about mostly with VB6 and excel VBA - moving to Access I find it has has a slightly different angle on the way things are done..! but learning day by day!!! Thanks again...very Much appreciated!!!

Any tips on the following? against every customer in my DB I have a notes field in the table. I want to be able to update the [notes] field with a string concatenation based on multiple entries from a form. my code (simplyfied) is along these lines. dim strNotes as String dim...

Hi, after searching through the threads on this forum I found the following code: cmdAddAppt_Click() On Error GoTo Add_Err 'Save record first to be sure required fields are filled. DoCmd.RunCommand acCmdSaveRecord 'Exit the procedure if appointment has been added to Outlook. If...

is it possible to manipulate smart tags? For example: I have field's in my DB for [email address] and [Projects] and [Date] is it possible to pass information to the subject line using smart tags?? ...eg: to: [email address] subject : "Re: " & [Projects] & " " & [Date] many thanks, I'm...

a big thanks to CEH & agehoops for the code... and thankyou all for your input...:)

thank you.... I found the answer here: http://www.access-programmers.co.uk/forums/showthread.php?t=115648

I need to produce a report that filters by a date range. How do I start my learning curve??? I created a form with two fields: one for [start date] and one for [end date] with a command button, what code do i need to play with??? I imagine i need something along the lines of: linkcriteria =...

you genius! They are hidden well..! Thanks a million...

in the risk of sounding thick.... I cannot find master/child links... Where Abouts am I looking for this? am I building an expression in the on open command??? Thanksyou..

I have a report which contains a sub report, I think i may be doing this all wrong... My report opens via a command button using the following code: [ProjectRef].SetFocus Dim stDocName As String Dim stLinkCriteria As String stDocName = "rptPre-Com" stLinkCriteria...

I now find myself working on a replica database, I dont know how it happened but it did, How do i change it to the design master? the 'Recover Design Master' is greyed out! feel free to use the words 'You Muppet' in any response!!!