Search results

ok, so just create a button with the code to enable them and thats all that would be needed? I'll start fooling with it in a test DB. Thanks!

open your main form in design mode, make sure the wizard button is selected, click the command button, place the button on your form and follow the wizards steps to create a button that opens another form. Kevin

I found the answer to this today as a matter of fact! do a search for RECORD COUNT and look for GHUDSON's post of " record x of y". the sample DB shows how to do it. Works GREAT!! THANKS GHUDSON!

I have a quick question about GHudson's post for hiding the toolbars and DB window. I wonder if GHudson could explain this statement a little bit before I start to fool around with this? "Ensure that you have a way to unhide the menu bars and tool bars before you hide them!" Do I have to setup...

your very welcome

open your entry form in design mode, make sure the wizard button is selected, click the command button, place the button on your form and follow the wizards steps. Kevin

this should work quite well....

good way of looking at it Pat, Thanks for the suggestion. Thanks again WayneRyan. Kevin

That was it!!!!!! Thanks!!!! Here is the code, maybe it will help someone else out in the future as well =DCount("[RecDate]","comparison","[RecDate] Between #" & Forms!DateInputforRMAsReturned!Text0 & "# And #" & Forms!DateInputforRMAsReturned!Text2 & "# And [Type1] Like 'Rec*'") Thanks...

I found another post you did with Justin72 http://www.access-programmers.co.uk/forums/showthread.php?t=81678&highlight=dcount+dates It looks the same as I am dealing with now. so i tried: =DCount("[type1]", "comparison", "[type1] Like 'iss*' AND " & "[RecDate]" Between #" &...

different error this time. "the expression you entered has an invalid string. A string can be up to 2048 character long, including opening and closing quote marks."

I agree this should'nt be to hard ( Ken has helped me in the past on something I thought was simple and it took us awile to get it right). I changed type --> type1 just in case. It still prompts me for type. =DCount("[RecDate]","comparison","[RecDate] Between...

below works for counting between the dates: =DCount("[RecDate]","comparison","[RecDate] Between Forms!DateInputforRMAsReturned!Text0 And Forms!DateInputforRMAsReturned!Text2") below works for counting like "iss": =DCount("[type]","comparison","[type] Like 'iss*'") I tried combining them...

Still working on Kens Idea - got them to work seperatly, just can't combine them. WayneRyan -- tried you suggestion and get a syntax error Still trying though. thanks

Not sure if this belonged in reports or queries, so I chose general. I have looked at several DCount threads but haven't quite found my answer. I want to use Dcount in an unbound textbox in a report. It counts the number of records in another table - comparison the first part of the statement...

maybe try to compact and repair then open it again??

I use wedge type scanners for data entry into my access DB. Whatever scanner you choose, make sure you get a copy of the programmers guide with it. using this you can set prefixes/suffixes on the data you scan, you can set CR or tab or strip characters, add characters.... so far working great...

I have gotten to the point where I have a graph to looks almost right! The only problem now is when an issue date is in Nov. and the corresponding Received date is in Dec. It still graphs the received date as nov. making all my issue vs rec data equal.? make some sense??? any thoughts...

I have gotten to the point where I have a graph to looks almost right! The only problem now is when an issue date is in Nov. and the corresponding Received date is in Dec. It still graphs the received date as nov. making all my issue vs rec data equal.? make some sense??? any thoughts?

morning all, I have a query giving me the data i need for a graph, parts being: issuedate, recdate, customer,..... I want the graph to show by month, issued vs received. example: 2 issued in nov 2004, 2 issued in dec 2004, 4 issued in jan 2005 2 received nov 2004, 1 received dec2004, 5...