Search results

Is there a way to make some records in a table read only? Thanks, Dave [12 days until retirement!]

I want to take a field from an open form and change a value in the underlying table based on that date- Table.tblClassSurvey.period.setvalue=Forms!frmTabSurvey!CompletionDate The form field is a ShortDate The table field is just the yyyy-mm datepart Thanks, [Down to 2 paydays left before...

I finished my work [I thought] on my latest 2007 database. As soon as a second user fired it off response time went WAY beyond usable. I split the database with the BE on the network and installed separate copies on three local desktops. Performance didn't change one iota. When a second user...

Trying to capture the user name in an append query- using RB: Environ("UserName") in a query row errs out Help, Please? Thanks, Dave

I need to open a form and display the last record created. I tried this: DoCmd.OpenForm "frmLocalRecords", , , "TrackingNumber=max()" but all it does is crash the application... any help, please? Thanks, Dave

I need to open a form to the newest record - the largest TrackingNumber. What is the cleanest way to do this? Thanks, Dave

The syntax I asked about here in this forum, for a filter, won't work with my if statement- What I am trying to do is run code if the case status is any status except closed OR with no date in the date completed field. This code won't run correctly: If "[CaseStatus]<>'Closed' or NOT...

I have a memo field on a form. I want to write certain events to that field, either on that form or into the underlying table. I want new event text added to that, preserving the data that may or may not be there. example: Issue opened on 5/5/2009 Isue assigned on 5/9/2009 Issue worked on...

This won't run: DoCmd.ApplyFilter , "[casestatus]<>'Closed' AND [TickleDate]<>null and [Assignedto]= '" & Environ("UserName") & "'" Help. please? Thanks, Dave

This code won't run: DoCmd.ApplyFilter , "[CaseStatus]<>'Closed' AND [TickleDate]<>null" I want all CaseStatus that are NOT closed and all tickle dates that are NOT null Help, PLease? Thanks, Dave

The code below will not open the correct record- that is, the record that matches the tracking number. It runs agains the very tracking number instead. If I put this code on a button and run it after the record loads it works correctly. Help with the code, and a little VBA lesson, please...

I have a form with about a dozen command buttons that open forms. My customers are asking if I can make the command buttons a different color if there is any data in the form the command button opens. They would like the color to remain changed forever once data is entered. Any suggestions...

What needs to be changed to get this code to work? No error message, just doesn't filter the record on the form I want to filter for just those records with the tickle date between today and 10 days from now... Thanks, Dave DoCmd.ApplyFilter , "[tickle date]= between today() and today + 10"

I am trying to clear the checkboxes [one for each record] when I close a form so it opens next time with none of them selected. I have tried 5 or 6 different ways to do this. =0 =Null ="" =false =no The most recent, below, doesn't work, either. No errors, just does not clear them. Private Sub...

My code for an option group [below] works fine. I now need to to another option group that checks both CaseStatus and assignedto. Some help with the if statement to require both matches? Thanks, Dave Private Sub Frame22_AfterUpdate() Frame33 = Null If Frame22 = 1 Then DoCmd.ApplyFilter ...

I just finished a customer demo of a new application. My customers asked me to build another form reached by clicking a command button on the main form. The two forms (and underlying tables) are tied via a tracking number (autonumber) field. They are planning on generating notes on this...

Using Access 2007 I have two tables/forms that are linked by the field 'trackingnumber.' When I have the main form open I call up the second form via command button and need to have it open the record that matches the main form. Thanks, Dave

Everything I have tried so far just changes the ID of the record on form 2... I just want the matching record :) Thanks

I thought I saw a 'display calendar for date fields' command and now can't find it. I have tons of date fields and would prefer not turning them on all over in the database. Where is this hiding from me? Thanks, Dave

I have a select query that works perfectly. If the query is empty I want a messagebox that tells the user there is no matching record. I can't seem to get the code to do this. I have been working with the NZ() function but can't make it work... Can someone get me started? Thanks, Dave