Search results

Don't pay too much attention to the code I provided. Hoped it would clarify what I'm looking for.

I'll explain it a little: - my main report is basic info about a person (name, age,...) - subreport1 holds info about all the cars he has owned - subreport2 holds info about all the houses he has owned Often a person hasn't owned a car or a house yet. In this case the subreport won't show at...

Access seems to hide subreports where no data matches with the main report. Is there a way around this? I still want my subreports to show.

Hello, I want to change the recordsource of a report when I open it from a form. Something like this: docmd.openreport "myreport" myreport.recordsource = mysql myreport.requery The report is showing fine but the recordsource isn't adjusted. Kind regards, Hans B.

I'm well aware that the lay-out of the table is wrong. The table is just an imported excel file which we get on a daily basis from the customer. As I need to delete the old table every day and replace it with the new imported excel file I'm not considering to arrange it according to...

Hello, i'm new to recordsets, can you help me out? Table layout: - contains reference numbers. Each ref number can hold multiple orders. - each reference is linked to 1 e-mail address - everything is stored in 1 table (no seperate reference and order table) - this means reference numbers are...

Please remove this thread (my sesssion got stuck when I clicked send)

Hello, I got a table which looks like this: # | e-mail -------------- a | me@x.com b | me@x.com c | you@x.com d | he@x.com e | he@x.com f | he@x.com Please note that column '#' is a reference number in the actual environment. I need to write a function which sends an e-mail to all of these...

Does anyone know an easy, preferably free and spyware free way of creating help files? Like the one you find under start > help ? All help would be appreciated! Kind regards, Hans B.

Hello, just noticed you can sort the way Outlook searches for your contacts in the address book (address book > tools > options > addressing). I'm wondering what use this has. In my situation we have one huge address book with business contacts next to a personal address book. Hope anyone can...

Hello, I want to refer to my pictures which are in a subfolder of the folder where my db is located. so the syntax would look something like this : pictures = (mainfolder)\pictures\pic.jpg Whats the correct notation though? Kind regards, Hans

Hello, I got a simple graph on my form based on the following query: date | ordercount: ------------------------- 16/11/06 20 15/11/06 18 14/11/06 19 13/11/06 18 10/11/06 19 09/11/06 18 My graph is leaving out the TOP record and my...

Hello, I have a table with part orders and I want to retrieve my five most recent orders in a query. That means I'll need the 5 most recent orderids How would I mention that in my criteria? Kind regards, Hans

Not sure how to do this, but I have a button on my main form that is supposed to send an e-mail out with some details of the selected record in my subform. DoCmd.SendObject acSendNoObject, , , "somebody@somewhere.com", , , Me!suborderlist.Form!Customer.Column(1) & " Issue "...

Thanks mate, that's the answer to my problem!! :)

My text box is in short time format. Somehow I was thinking about the month aswell, but we are still november so he should give me 11 then.

Hello, I'm trying to separate a given time in hours & minutes. Let's say for example that I've worked 7 hours and 30 minutes. Therefore text box txtworked = 07:30. vtimeworked = txtworked vhrs = Format(vtimeworked, "hh") 'results in 07 = ok vmin = Format(vtimeworked, "mm") 'should be 30 but...

Hey guys, I solved the problem :) Here's what I needed: vcheck = DLookup("fldchecklistid", "tblchecklist", "flddate = #" & Format(Forms![frmmain]![txtdate], "yyyy-mm-dd") & "#") Thanks for the swift replies, turns out you guys were right ;-)

The code looks like this now : Const JetDateTimeFmt = "\#mm\/dd\/yyyy hh\:nn\:ss\#;;;\N\u\l\l" Const JetDateFmt = "\#mm\/dd\/yyyy\#;;;\N\u\l\l" Const JetTimeFmt = "\#hh\:nn\:ss\#;;;\N\u\l\l" vcheck = DLookup("fldchecklistid", "tblchecklist", "flddate = " & "#" & Me.txtdate & "#") MsgBox...

I'm not sure if that's the problem. But somehow I can't see anything else being wrong with the code. This is really frustrating me now as it is holding me back to continue on my project...