Search results

I tried the above and it gave me a few problems. I suppose it all boils down to the fact that I don't really understand some of the Access terminology. What is a 'standard' module. I think I know what a project is (= a session using Access after double-clicking a .mdb thing) ... I also know what...

I need to dimension variables and define string constants which will be relevant to all forms in a particular project. Can someone tell me where I put these? Thank you (in anticipation)

Code to put text string into a Word document? I need some code to place a text string into (the first line of) a Word document. The problem is, I don't want to see the document at all ... just put the string value into it. Can anyone help?

Thanks for the two replies, Meltdown and Sergeant. Meltdown, same thing happened again with me.frmSessions.visible=false .... it is trying to interpret frmSessions as a field and returns an error. However, Me.Sessions.Form.butBackCtlPnl03.Visible = False DID work. Thanks again Sergeant...

I tried it and I get error 2465: can't find the field 'frmSessions'

... why oh why is it so difficult! I have tried lots of different combinations and I am currently tearing my hair out with frustration. My button is butBackCtlPnl03; my subform is frmSessions; the control is Sessions and my current code (on main Form Load) is...

Thanks RichO ... it worked perfectly :D ... as a function for a calculated variable in relevant queries. I was trying to use the 'ddd' form in the format property (duh!)

I have a form field which displays the date in medium date format - thus 6/2/2005 (UK style) for the 6th Jan 2005. I need to format it with an added short day of week at the beginning - thus Wed 6/2/2005. :confused: Can anyone help? Thanks.

Roy ... thanks again ... worked like a dream!

Yes, Roy ... I need to filter the records of the subform (in the same defined way) each time I select a different record from the main form. You have now got me thinking ... and I am sure you're correct that the filter is only OK for a main form. I think I will try defining a query that filters...

Can anyone give me code for selecting a document (Doc1.doc say), copying it and then renaming the copy (Doc2.doc say). The document will have a known path on my C drive. Thanks.

Thanks jgc ... I will try again shortly Incidentally, in your code above, I can see a form and a subform but no control between ... is this OK?

I am trying to address a subform field. If I address the subform as a separate form, the following code works OK DoCmd.OpenForm frmSessions, , , "Issue = true" :) However, once I try to access it as a subform, I get a bit lost. The main form is frmJobSess, the control that holds the...

Yes, thanks Col ... this seems to be most of the way to what I want to do. Isn't it so easy when you know how! :o

I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :( What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record. I have Tables A and B in a 1-to-many relationship and I need to be...

Hi Lon3 ... I am not an expert Access user and programmer, but it seems that the algorithm for this procedure is fairly straightforward. You define a new field (call it sortkey) which is initially defined in order from 1 to 'no of records in set'. Now, suppose we are currently positioned at...

oops ... It seems I didn't succeed in attaching my picture. Trying again ...

KeithIT, thanks for the attempt to understand my ramblings ... I am aware of the things you have mentioned. As much as I tried, I wasn't able to describe clearly what I need. I'll try again ... ... forget the form/subform structure for now. I currently have a (sub)form that displays records...

I have a problem that is probably very straightforward to you Access experts. A brief description of the salient parts of my setup are given as numbered paras below. 1... I have 2 tables: Jobs and Sessions in a defined 1 to many relationship. 2... I have defined a form in parent-child...

This two minor points of code have given me a headache recently :mad: and I thought I would pass this tip on. When using FollowHyperlink code, the address (whether Internet or own computer doc) should be absolutely literal. Thus: "http:\\www.website.com" and NOT "www.website.com"...