Recent content by AmiDenise

When you modify the data in the query, or in the query's source tables, the changes should be automatically updated in the flexgrid. If the changes are not being reflected in the flexgrid, I'd try requerying the record source. If this doesn't help, reply with more detail about the problem &...

DoCmd.RunCommand acCmdSaveRecord will save the changes without moving to the next record. HTH, Ami D. Shroyer, MCSD AmiDenise@yahoo.com

The best solution for this is to start a transaction when the form opens and commit it after each record it saved. That way, you can rollback the transaction (undoing the action) on both the main form and the sub forms. The following MSKB articles explain the problem you're encountering and...

FYI, there's a typo in the last line of the properties that I didn't catch until after the post (naturally). Here's the corrected version: Me.ProgressBar.Max = NoOfRecords Me.ProgressBar.Min = 0 Me.ProgressBar = Me.ProgressBar.Min Again, hope this helps! Good Luck! Ami D. Shroyer, MCP...

Stefan, First you'll have to add a Active ProgressBar Control. This control should be in your access controls. (mscomctl.cx) Set the minimum and maximum of the progressbar. Me.ProgressBar.Max = NoOfRecords Me.ProgressBar.Min = 0 me.prograssBar = Me.ProgressBar.Min Create a loop that...

Hi Jon! Access has a function to generate a random number. It's "rnd". Information on it can be found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vafctRnd.asp To insert your randomly selected number into a new table, use the following sql...

i recommend creating a form using html. on the text box for the password, set a password mask. for the form's action, pass the inputs from the user name and password text boxes to a procedure that logs the user in to the database. here's a link to a java script that does this action...

this post has code for disabling the mouse wheel in a form. http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/27/pid/181/fid/871 Good Luck! Ami D. Shroyer, MCP amidenise@yahoo.com www.amidenise.com

Sounds like you have a corrupt combo-box. Have you tried recreating it yet? Ami,MCP AmiDenise@yahoo.com

Hi, In order to fix this problem you need to install or reinstall Microsoft Photo Editor. The following KB article details the steps that you need to take to resolve the issue...

Sylvia, Do you want to update the SQL table with the data in the Access table? Do you want to create a VB app that reads data from Access & SQL? What versions of Access and SQL are you using or considering using? A little more information would make it much easier to provide pointers. Let...

Rich, Can this be done? Absolutely! Sample code: Private Sub cmd711OpenHTML_Click() On Error GoTo Err_cmd711OpenHTML_Click Dim strFile As String, strMonth As String, strYear As String Dim strDate As String, strCriteria As String strMonth = Left(Date, (InStr(1, Date...

Matt, The following KB article details sample functions for retrieving user and group information in your database. http://support.microsoft.com/support/kb/articles/Q123/0/79.ASP?LN=EN-US&SD=gn&FR=0&qry=current%20user&rnk=11&src=DHCS_MSPSS_gn_SRCH&SPR=ACC If you create a function to pull...

The following KB article details how to create application roles on sql server. http://support.microsoft.com/support/kb/articles/Q243/0/53.ASP?LN=EN-US&SD=gn&FR=0&qry=Application%20Roles&rnk=2&src=DHCS_MSPSS_gn_SRCH&SPR=SQL Should you have any further questions, you may want to search the...