Search results

I now see the error of my asking Access to evaluate text fields. So as not to start from scratch I'd like to persevere with my method (as it was working and I was quite pleased with it), but convert my dates in a different way. I am trying to group a range of dates by their months, and then do...

Thanks for response George - I wait with baited breath.... I thought that comparing text to text would be rock solid as there ain't no date calcs going on behind the scenes, so silly me!

I have a time recording database that has been working fine for several months. A DSUM and IIf functions have now stopped working, and I think it must be to do with the month changing to 2 digits.... My DSUM relies on the conversion using functions, of any given Access date into what I have...

Got it with Private Sub Form_Current() If Me.[created_date] = Date Then Me.Hand_made_Pot.Enabled = True Else Me.Hand_made_Pot.Enabled = False End If End Sub Seek and you shall find

I want a subform to be editable if a date field on the form [created_date] is today's date. I want users to be able to edit that date field so that if they really need to, they can edit the fields on the form. I have done some searching and found code to use on the "On Current" event of the...

Hi. We have a problem where on exporting a table in Paradox (db) format from Access 2007, the file name is truncated to 8 characters. This wouldnt be an issue (i.e. a simple rename following export would sort it), but there are other hidden files that the export engine generates that means a...

should have added that I'd have to do a screenshot and paste into a raster editor etc as I cant find away to print directly from Access......

Ive searched for this, but not found any references. I want to print out a table design view, but can't find where to control the font to get things on one page (big table...). Where can I customize the design view ? Access 2007. Thanks Matt

Thanks Rich, but how would I use that? What action am I trying to enforce (in code terms). I dont want to add new values to the combo list, only allow the user to start choosing by typing into the box without first having to drop the combo down. Reading a little more, I wonder if the macros...

I have a question regarding combo-box behaviour which is limited to a selected set of records based on a query of a bigger record set. If I click the dropdown arrow and type, the combo behaves fine. But if just start typing values, an unknown/recognised and not-in-list value appears (9.90990)...

No I want to get rid of the spreadsheets which is what people are using at the moment, and automate the process of merging the data. I have only 4 users using the pilot dbases currently - and 2 I have now merged. This is testing prior to rolling out in a few months maybe to the rest of them. I...

OK, 2 of the 4 pilot databases I have now merged in a split BE/FE database. Im amazed at how painless the first bit was. All seems OK now, but I had a bit of a job with Autonumber PKs that are used to link other tables together. I could not simpy append data into tables as the new autonumber PKs...

The security complication I have always avoided and used NTFS security on the network - essentially using users network logins as validation of their status. This does not permit differential access to forms etc within the database and only works to either permit or deny access. I have kept away...

Dear experts, I am now wanting to develop further a time-sheet recording and flexitime calculating database that I was developing a few weeks back. This is running smoothly and does what I want it to do. I now want to take a summary of information from perhaps 30 of these databases (one for...

on an AfterUpdate on a Subform control Works like a dream. Thanks RG.

I had tried the Refresh several days ago, but it did not work. But this may have been because my syntax was wrong rather than the Function would not work! Perhaps Ill try again!

Leigh, thanks very much; having set this to a control on a text field on the mainform it works. How can I now set this to operate from an after update on a control on the subform? Thanks again Matt

2 sums on 2 other Subforms, a DSum, A DLookup, and an IIf. Matt

I have been trying to do this, but clearly not getting the syntax correct. This is all a bit new to me, so I am not surprised by me getting it wrong! Underlying my problems are perhaps the fact that my understanding of VBA is poor and so I am really jumping in at the deep end with little...

I have been trying to write code to effect the return to the last edited record after a requery of the main form following data update on the sub. I am not making any progress. I have chased various threads that have examples of similar things but nothing seems to do what I need. Would any...