Search results

yup, I pretty much thought that's what I'd have to do. something like: 1. Import table to TEMP table 2. Run an UPDATE query to import the data from TEMP to my exisiting table 3. Delete TEMP table Oh well thought I'd check with you lot first in case there was something I was missing. Cheers...

Hi all, Hopefully this is just a quickie but I'll paste a bit of text form the MS help to illustrate (mainly because I'm too tired to think straight today!). MS Access 2002 help for the TransferDatabase Action states: Is there a way to use this command (or could you suggest another one) that...

Hello All, Could any of you give me some suggestions on the best way to do the following and save me loads of hours fiddling arround: I have an Assets Database that contains linked tables contaning user details from our Helpdesk database. I have made a blank cutdown version of the assets...

Perfect! Worked like a dream! Thanks again Marc

Ah I may not have explained myself properly in my original message. what I'm after is a list in decending order of the records that contain the most of the keywords searched for. Also because of the way I'm writing the code I'd like to do it with a single SQL query rather than one query looking...

I'm trying to build a query that seaches keywords in a table and displays matching results in order of best match. To do this, I thought I'd write a bit of code that takes the search words, writes SELECT statements looking for each word in turn, UNION ALL the results together and do some group...

Duh! Knew I was being stupid. Thanks!

OK, it's late (4am) and my brain may have just melted so I appologise in advance if I've missed something stupidly easy. My problem (simplified): I have 2 tables called A & B table A has a primary key called PK_A table B links to it using a field called Ref_A E.G. Table A: 1 2 3 4 5 Table B...

I know you posted this question a while ago but I was trawling through the help in access for something else and found this little snippet (below). As soon as I read I remembered your question. from the MSAccess 2002 help: Cross-product or Cartesian product joins If tables in a query aren't...

I'm not sure I get you completely, but it sounds like you're gonna need a pivot table.

Nailed it! I trawled through the help and found Me.Properties(x) What I did in the end was create 12*31 textboxes in a form (not a report) and used a FOR loop to set the content and background colour of each one on the fly. If I get some time I'll make a demo and upload it. TTFN Marc

I think I get you. However I'll need more than 5 boxes. what I'm looking to produce is a year calendar that looks roughly like the attached jpeg.

Noted. Please find the rest of this thread at the link provided by Rich above.

Nice website. Now added to my list of favorites. Unfortnately there's not much there regarding year calendars and I cant ope the mini-calendar project (in access 2002) as it tries to launch an avi and passes it a prameter it doesn't like sending the whole thing into a loop that I have to End...

Just tried it. Keep getting the following error: I think there be something else I have to do create textboxes at run time to tie them in to Access. However I can't find any information on the subject and there doesn't seem to be a method to create/add/copy an instance of a textbox in code...

(OK I did post this in the reports forum but it's probably more of a coding issue - my appologies in advance - I'm not really in the habit of multiposting - honest :) ) Hi all, I was wondering if it was possible to create textboxes on the fly in a report using code. Something like this...

Hi all, I was wondering if it was possible to create textboxes on the fly in a report using code. Something like this: Dim YearMatrix(1 To 31, 1 To 12) As TextBox Private Sub Report_Open(Cancel As Integer) Dim x, y As Integer For x = 1 To 31 For y = 1 To 12 Set YearMatrix(x...

How good is that !!!:D It's amasing what little command pass you by when you teach yourself. In case anyone wants to know this was the final working code: Function IsStateHoliday(InputDate As Date) As Boolean IsStateHoliday = Not IsNull(DLookup("[StateHolidayID]", "StateHolidays", _...

No Problemo

Re: Problem in running a batch file OK, first of all you might find it better practice to use notepad rather than word as it won't autocorrect (read that as screw up) your text. second your execution path in the batch file contains spaces. There's a few ways round this. 1. use the non-8dot3...