Search results for query: *

Not sure how complex your update is, but it sounds like you are just updating data in tables across multiple Access databases. If that is the case, one possible solution would be to have your "Do Updates" database create a link to the appropriate table(s) in each of the other databases and...

Although that would probably work, it needs to stay as an mde. TwoOdd -------------- Good judgment comes from experience, and experience comes from bad judgment. -- Barry LePatner

I'm trying to hide the database window, but even though it hides it still shows the button for it on the taskbar. Can someone show what I'm missing? Version: 2002 on windows xp pro I've unchecked the show db window in the startup options, and I selected a form that has one label on in and...

I have a combobox with a list of values that the users can select. The users also have the ability to de-activate or remove items from that list to keep users from using that option on future records - the items will still exist in the source table of the combo box, they will wont be displayed...

Okay, I finally got it to work. You're idea was on the right track. Here is the actual code that finally worked: [code] Dim frm As Form Set frm = Forms!frm_Main.Form!frm_SubForm.Form frm.frm_Revisions.SetFocus frm.frm_Revisions.Form!fld_RevID.SetFocus [\code] Thanks Remou - a...

It runs through the code without any errors popping up, but it just won't put the focus on the nested subform. I have double and triple checked the spelling on the form names and fields and have tried to set the focus to multiple fields on the nested subform and still nothing. I also have...

Still doesn't want to work. It sets the focus just fine to the main subform (and any field on that subform), but from there, I can't get it to focus on the nested subform. I have even tried the following syntax: Forms!frm_Main!frm_SubForm.Form!frm_Revisions.Form!fld_RevID.SetFocus But again...

I'm trying to set the focus on a field in the subform of a subform. This works to set the focus on a field in the first subform: Forms!frm_Main!frm_SubForm.Form.fld_ID.SetFocus There is a subform called "frm_Revisions" on the subform "frm_SubForm" and I want to set the focus on a field in...

Thanks. Had to do a little converting to VB, but was able to make it work. Here is the code for those who need it in VB (this is in the RowDataBound event of the gridview): Dim MyButton as Button If e.Row.RowType = DataControlRowType.DataRow Then MyButton = e.Row.Cells(1).Controls(0) If...

here's the pertinent html code: <asp:GridView ID="MyGrid" runat="server"> <columns> <asp:BoundField DataField="fld_CountNotes"> <asp:CommandField ButtonType="Button" EditText="Notes" ShowEditButton="True"> </columns> </asp:GridView> In the RowDataBound event, I would like to do something...

I have a gridview with a button that reads "Notes" and if there are notes for that given record, I would like to change the text on the button to read "Notes*". So some rows will have a button that reads "Notes" while other rows will have the button read "Notes*". The problem I'm having is I...

I have a buttonfield in a gridview that I want to change the text dynamically when the row is created. Any help would be appreciated. If more information is required to answer the question, please let me know. Thanks in advance TwoOdd -------------- Good judgment comes from experience, and...

Just found an error in my sample code - was modifying it to post and deleted one too many lines in the second sub procedure. Here is the corrected sub procedure just in case someone needs to use it: Private Sub cmd_Export(varQuery, varWorksheetName) Dim MySQL As String Dim rs As...

Looking at your code more closely, it looks like your are placing your values in the same line on the spreadsheet: .Cells(3, 7).Value = rst.Fields("BranchNumber").Value .Cells(15, 11).Value = rst.Fields("GL_Acct").Value .Cells(15, 12).Value =...

First I create and save the query in Access then use the following two sub procedures for exporting - The first sub procedure calls the second one and this allows you to export multiple queries to the same spreadsheet as multiple tabs - it also deletes the 3 default tabs that Excel Creates with...

Well, I couldn't get the typename function to give any other value than 'IStringType'. So, I figured out a way to check if the submitted value is an integer: Function CheckInt(varNumber) Dim x If IsNumeric(varNumber) Then x = varNumber - Cint(varNumber) Else x = 1 End If If x <> 0...

Thank you. I realized what I was doing about the time you answered the question. I was about to do a search on how to check the value type, but you answered that as well - thus a star for you! Saved me another half hour of searching. Thanks again. TwoOdd -------------- Good judgment comes...

I'm getting the Error Message (see subject) on this function when varNumber actually equals an integer. Can someone help me on this? Here is my Function: Function CheckInt(varNumber) On Error Resume Next Response.Write "Number To Check:" & varNumber & "<br>" If Err.Number <> 0 Then...

Okay, I found the answer. Me.[insert subform name here].SetFocus If Me.[insert subform name here].Form.CurrentView = 1 Then 'Current view is FormView - Change to Datasheet DoCmd.RunCommand acCmdSubformDatasheet 'Change the button to read 'Form' Me.[insert...

I am wanting to put a button on a main form that will toggle the subform from FormView to DatasheetView and back. I have found out that the FormView has a value of 1 and DataSheetView has a value of 2, but have not been able to find the syntax to change the CurrentView value in VBA. It seems...