Search results

Solution: Re: Dcount syntax: between two user defined dates =DCount("*","[BFReceivedChrysalis]","[orderdate] between [txtendDate] And [txtStartDate]")

My problem is with the exact syntax "Between" two user defined fields. I tried to deduce from the example, to no avail. Thx

The following is what I'm trying, but it throws an #Error, =DCount("*","[BFReceivedChrysalis]","[orderdate] between [txtStartDate] and [txtEndDate]"). Hope it is simple...

pbaldy, Paul, thanks, your comments about the form name and table name pointed out that I used a reference to the table in my code instead of the form itself. Thank you for your help, it works great now. mvorous

Form name: mainmenu, Table name: maintable. Do you mean to reply with the *.mdb file? if so, how do I attach the file if my prompt is a URL address? Haven't done that as yet, sorry. thanks for your help

I used... Me.RecordSource = "SELECT MainTable.* FROM MainTable WHERE (((MainTable.NursingStation) = Forms!maintable.lstnursingstation)) ORDER BY MainTable.Room;" It prompted me with an "Enter parameter value... Forms!mainTable.lstnursingstation ?????

Access 2007, geered toward Access 2000 version... I have a cont. form (Room, NursingStation, patientname etc.) that I want filtered based on a selection a user makes from a list box "lstnursingstation" in the header section. They would pick a Nursing Station (from a list of 7) and the records...

If you mean yes, I have, didn't seem to help. thanks though, mvorous

I have a simple form that will inconsistantly shrink to an unusable size. Pop up yes, Modal yes, Auto center yes, autoresize no, fittoscreen yes, border style sizable - "only because the user has to resize it occassionally". The form itself doesn't seem to hold its size consistantly. Plz see...

Thanks RuralGuy, Format(Date()-1,"yyyymmdd") worked nicely. mvorous:)

Hello, I have to subtract a day from today's date in a submitted billing file. How would I do this with the following format? Format(Date(),"yyyy") & Format(Date(),"mm") & Format(Date(),"dd"), which by itself equals 20090110 I tried simply... Expr1: Format(Date(),"yyyy") &...

I went back and re-input it correctly, worked like a charm. Thx all.

Honestly, I was frustrated & probably didn't enter it in right, when I did get it, I never looked back. Your's looks cleaner, either way, thx for your input mvorous

Mike :) That did it, couldn't be happier! I never would have thought of that restructuring the query format for date, you're the man, thanks again! mvorous

No, I deleted the saved specification name and have created many since then... When I Run my Query actually, the date reads as 12/18/2008 The output of my query "exported" in txt form is 2233445 112233445 4302020 04 2008 12 18 0 00 00 What I need... 2233445 112233445 4302020 04 20081218 00000...

Unfortunately, I tried Now(), but it left the spaces in as well. Any other ideas? mvorous:(

1. When I Run my Query actually, the date reads as 12/18/2008 4:14:12 PM The output of my query "exported" in txt form is as shown below "what I have". I cut out some of my original txt file for brevity, here it is in full with the SQL at the bottom... What I have... 2233445 112233445...

Hello, I have to export a Query in txt form, "fixed width". This is what I have as a text result... 2008 12 18 13 56 08 This is what I need for IT "no spaces" except between Year/day & time... 20081218 135608 How can I get the date to show like I need it? Thank you in advance, mvorous

Hello, I would like my user/manager to be able to drag an image, bmp, jpg, etc. over to a bound image field in my Access 2000 database. Can this be done and how please.:confused:

That worked fine, I don't know what I did at first but thank you all very much. mvorous