Search results

Not sure if this should be a query question or a report question so I'm starting here. I'd like to create a report for the number of tickets each officer wrote within a date range. There are multiple ticket types (examples: MV4016, Parking, but there could be more). I can generate a query...

Thanks Spikepl. That's the connection I was looking for. In the attached database, changed the data source for the Short date combo to: SELECT DISTINCT Format(Table1.dtmMyShortDate,"General Date") AS DocketDate, Table1.dtmMyShortDate FROM Table1 ORDER BY Table1.dtmMyShortDate DESC; and got...

I setup a sample database with a single table (Table1). In the table there is an ID column and then two date columns which are both typed: dtmMyShortDate - datetime, format "Short Date" dtmMyGeneralDate - datetime, format "General Date" I created a datasheet form to be able to view the data...

Reason I thought I needed to change was because the following query on the table only displays the date portion: SELECT DISTINCT tblCases.dtmCaseFirstAppearanceDate FROM tblCases ORDER BY tblCases.dtmCaseFirstAppearanceDate DESC; I use this query to get a distinct list of first appearance...

I've got a database that's been in use for 10 years and there's ~ 40 copies of it out there now. I have dtmInitialAppearanceDate in the database already and have it stored as short date in the column definition. Some newer customers are asking that I now also store the initial appearance time...

Set the tag to "?" for each of the controls you want to resize and then add the following: Put this into the load event for the form and subform.

For split forms, expand the size of the form header so you have enough room to include your controls. If there isn't already a form header, add one and put your controls there.

Ok, doesn't make any sense why this appeared to work on one combo but not the other but after I switched the split form to allow additions it is working. Appreciate the help guys.

Created a new form from scratch and rebuilt the controls from scratch and added the on error code and it was telling me the cmbDefendant has focus which is the name of the control. I'm using this in the header section of a split form so I tried renaming the control to cmbDefendant2 in case I...

Ok, weird one here. When I try to get the .text value from a combo as the user is changing the value, I get a "Control must have focus" error. But it should have focus, I'm editing the @#$@# thing. Here's the only code on any of the control events: Private Sub cmbDefendant_Change()...

Thanks PNGBill, but how do I get rows for the payments that haven't been made yet without creating dummy records in a table to display? Use VBA as part of the on open... hmm... ok I've got more digging to do.

Ok, This may have been covered elsewhere, I'd love URL's to point look at. I have a table in the system that lets the user add payment plan information with the following info: Start_Date (date plan starts), Days_Between (days between each payment, 30 is default for 1/month), Payment (amount...

I'm working on a project and wasn't sure if this post should go here or in the VBA section. Since its more of a theory question figured I'd start it here. I need to read data from a 3-rd party Access database and pull the data from 3 separate tables in the remote database into a single table...

Also, not sure if you are straight 32 or 64 but if you are going to work in a mixed environment you will need to compile 32 bit only. I have another post here on the forums with those details... I think.

Please have a look at the http://support.microsoft.com/default.aspx/kb/317109 which talks about the proper way to release the COM objects while automating Office applications. Took a bit of experimenting but I finally got it to clean up properly. Good luck.

Thanks for the feedback guys. My original thinking was that it would be better to have 2 different front ends, if for no other reason, to get all that "extra" code out. After playing with it both ways, Bob was correct. I spent a couple hours last weekend trying to only get what was absolutely...

Thanks guys. Couple other considerations: - These extra users are read-only so I'd want to open the database read-only. Guess I can tweak the forms so they open the tables read-only - Was thinking since the users only have access to 1 form, that I'd add another custom ribbon but I haven't...

Are you building/running this on a 64-bit machine? If so, you need to set your project to compile x86 only. My thread with the problem I was having and the solution are at http://www.access-programmers.co.uk/forums/showthread.php?t=199196 -Lution

YAAAYYYYY found the solution which can be found in the 2nd post in this thread: http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/60591b23-c601-4f1c-bd84-a26d6a977fd8 [/LEFT] Changing the compiler setting from Any to x86 solved the problem. Hope posting the solution here helps...

Question for the crowd: I have a a split database that's in use. Several of my customers have asked me for a limited version of the front-end that has a limited menu and only a couple of the forms available to users. All the data is read-only in for these users. I'm trying to decide if I should...