Search results
-
M
Dcount syntax: between two user defined dates
The following is what I'm trying, but it throws an #Error, =DCount("*","[BFReceivedChrysalis]","[orderdate] between [txtStartDate] and [txtEndDate]"). Hope it is simple... -
M
Filtering records based on user selection from lstBox
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... -
M
MDI form keeps shrinking... :(
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... -
M
Date minus a day
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") &... -
M
Export Query to *.txt file question
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 -
M
User drags an image into bound field, doable?
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: -
M
Programmatically select a record in a list box
Hello, I have a form with a simple list box of records. I would like to click a button and have a particular record selected -"highlighted" as if actually clicked upon by user. Can this be done? Thank you, mvorous -
M
Counting of records in a continuous form
Hello, I have a form that has its default view set to continuous form. I would like to have a textbox store the record number with each new record that is created by the user. The first record of course, would be "1", the second would be "2", etc. What property of the recordset stores this... -
M
I need to return the number "index" of the selected record
Hello, when a user selects from a combobox, say the fourth item in the list, I need to have that "4" value returned to a textbox. Simple, I hope, thank you in advance. mvorous:confused: -
M
User drag -n- drop from listbox's (possible?)
G'day Can anyone direct me to code that shows drag -n- drop functionality for the users? I would like to have the user drag a name from listboxName & drop it into listboxSelected. Thank you, mvorous -
M
Simple problems with fonts
Hello, two simple issues about fonts. I have set what I could find in Access Options to address these issues, but still it persists. 1. When I insert a simple button I initially get font "Calibri". I want it to always be the same as the rest, such as "Tahoma". 2. In the VBA code editor... -
M
Weird simple code not working
Hello, first post..., I have installed, and now have re-installed the MS Office 2007 Suite Professional onto my Vista OS, due to this problem. I am simply trying to use VBA to make a textbox invisable when a button is clicked. Option Compare Database Private Sub cmdMakeTxtInvisible_Click()...