Search results

I'm hoping somebody can help me with this: I want to create an array inside the loop to record 2 sets of data: a name, and a number. I don't know how many records the loop will run through, hence I need the array to be dynamic. If anybody can help me out with some code, I would be most...

I have a stored query in my db. The query gets the recordcount of all the items in a table. In my VBA, rather than code a new db conection, set a recordset etc, I want to execute the query using DoCmd ======= DoCmd.OpenQuery stDocName, acNormal, acEdit ======= The above line displays the...

Hi all, Can I set the default path for a dialog box to look in when called?

aye done Cheers bud! :)

I'd like to display the contents of 2 fields in a single textbox. Any help is greatly apreciated :)

I need to duplicate a recordset in a table. How is this best done please? 1 set up a temp table, copy the recordset to the temp table and use an append query to re-added to the original table? or do it in code using recordset.clone? I'm not sure of how to do this using either method, so any...

thanks Thanks for that - I really appreciate it! :)

Can I use the len function in a query's criteria field? I've tried a few things like: (len<4) [len<4] etc cheers for any help

Hi all, I want to build a form which displays a repeated (as in the data repeater) monthly view for a number of people. Each day is represented by a clickable button (or similar object) which then calls another form in it's click event. I'm not sure where to start, so I'm wondering if anybody...

cheers Nice one - at least that focuses me on the prob! Thanks a lot!! ;)

I'm looking for some help on this one: I have a macro based on a query that returns all the entries created today: [Date_Created]=Date() This works fine on my machine (Win2k , svp 6, Office 2000, svp 2) but doesn't run on the machine I needed it to run on! (Win2k, office 2000 - unknown svp...

thanks PS JobID is not numeric - it's text I fixed it by creating and deleting a dummy entry "." in order to trigger the auto_increment field (ID). From thereon I can just get the value fo ID and append it to what I need Cheers all

ok Next time I'll use the help, not the forum thanks

sigh OK - this is the way I'm going about this I have an ID field, set to auto_increment and a JobID field, set as PK In my form, I have some code behind the ID textbox control's AfterUpdate event: ' add this ID num to the JobID plue other bits... JobID.text = ID.text & "test" == But it...

ah ok - I'm with that But I came across a reference to this in 'help' (type in "multirow and you'll see MultiRow Property explained) cheers for that anyhow! :)

I want to set a textboxe's controlstyle to multirow, but I can't find this property in the control's property list, nr can I set it in code: MyTextBox.ControlStyle = MultiRow That just makes Access tell me to use the properties list Any help is appreciated :)

ok Got that cheers :)

Hi peeps, hoping somebody can help me with this one: I have a PK field called ID. It's value is autonumber but I want to add to that the month and year eg: 41.02.04 42.02.04 43.02.04 Does anybody know how to go about this?

agh Neither have I :) It still doesn't work. Bugger it - I'll swtich the form's recordsource and then check the recordsource each time I apply a filter Thanks so much!

agh not sure how to add that criteria withn brackets :( I have a query qorking now, showing today's jobs, but what I really want is to click on a button and trigger DoCMD. Applyfilter (which I still can't get working) otherwise I'd have to change the form's recordsource to teh query (which...