I have two MS Access accdb databases. Both database are password protected. The first database I can compact fine no issues at all. Below is the code that I use to compact it. object[] oParams; object objJRO = Activator.CreateInstance(Type.GetTypeFromProgID("JRO.JetEngine")); oParams = new object[] { "Provider=Microsoft...
Hello Everyone! I have a question that encompasses both SharePoint 2007 and Access 2007. Background: Over the past 6 months our SharePoint 2003 sites have been migrated to SharePoint 2007 creating issues with some of the lists because the column names had more than 64 characters (we used the column names to hold the actual question) ...
So the function =Now()....is there a way I can use this and only get the date, not the time? or is there just a function for this idea? thanks Justin ...
Is it possible to build an unmatched data query using two tables with a tracking a unique value field and also another value in the row as well (that value will not be unique). For example I want to track a unique customer code from an invoice on a new table, compared to last month's invoice. The non unique value would be a "product co...
so if I have a DAO recordset returing values, and I use Format$, is there a way to set the font property of what is only contained within the Format$ portion? For example I have this: "Metric #43 = " & Format$(rs!Metric43, "Yes/No") so this is actually for ppt automation, not an access form. I want the first string to be unbold, and ...
so if i do a SQL statement like so: sql = "SELECT * FROM tblMain" set rs = currentdb.openrecordset(sql) what method can i use to view every "field name" in this collection i have just created. i am getting some very strange error stating that the item is not found in this collection. i know the field exists in the table, i have...
Hey everyone! I need to gather some information from a Microsoft Access form and I need everything to be as organized as possible. There are a lot of columns that can be filled out, but don't necessarily apply to everyone and I want to keep everything as clean as possible. In a form, is there any way to have certain input boxes displa...
SO I have a subform, that simply has one chart object on it. Its small, and this is the only purpose of this sub. Then I have about 10 forms that each have a sub windows with this form as it's child. I use a UNION query to show the current balance of 10 accounts on each form with this chart for comparative purposes. Everything works fine...
I have two tables. CustomersTable and BusinessDirectory Both tables have a column called businessName. my CustomerTable has a columns cid, customerID, businessName my BusinessDirectory table has columns bdid, businessName, getID I want to update the getID field in BusinessDirectory table by customerID in CustomerTable where the busine...
I have a simple Access macro that opens two forms and filters them based on input from the user. I used parameter queries to accomplish this, so my Where condition for both reports reads: [PONumber]=[Enter PO Number] As it currently stands, an input box pops up twice - once for each report. I was hoping that I could somehow re-use t...
I am working on a program that transfers a file from a CentOS VM, and parses the file for multiple Start, finish, and host ID values. After this the values are then moved into an Access database for tracking purposes. So far I am able to pull a file down from the CentOS VM and parse it for the desired values. However, I have run into a f...
hello, I am trying to update a control in a subform. Actually I am calculating the number of months. here is the code: (which doesn't work!) While (Not Me.Form.Recordset.EOF) months = Round((Me.End - Me.Start) / 30, 0) Form_FinanceSubform.[number of months] = 0 Me.[number of months] = months Me.Form.Recordset.MoveNext Wend the error ...
For query data like this: Name , Details JEFF , TEST1 JEFF , TEST2 JEFF , TEST3 BOB , TEST1 BOB , TEST2 How do I query so that a numerical sequence (1,2,3...) can be added that resets back to 1 each time the name changes (ie from JEFF to BOB)? Is it possible to use the DCOUNT function? What ...
Hi there, thanks in advance for any help I'm using a macro to perform a filter on a split form by taking a value from a text box. Everything works fine, except for fields that use a lookup to get there value. Unfortunately I cant figure out how to search the shown value in the field as opposed to the bound column. Should I use dLookUp...
Hi there, thanks in advance for any help I am trying to figure out how to make pop-up sub form the only available focus for a user in a database. So that the user is essentially forced to complete/save/close the sub form, before they can return to the parent form. This I imagine involves disabling the parent form and trying to keep it a...
i have this statement in access: SELECT * FROM accountsnew WHERE [Panels] not like '*IT_OXYC,*' and [Panels] not like '*OXY_SN,*' and [Panels] not like '*OXY_S,*' and [Panels] not like '*OXY_N,*' and [Panels] like '*OXYC_SNEG,*' or [Panels] like '*OXYC_PNEG,*'; for some reason it is not returning the proper dataset. when i look more d...
I'm sure there's a simple solution to this, but it seems to elude me. So I have a form with a RecordSource of SELECT * FROM Table1 WHERE id=[@id]. (Yes, I know SELECT * is evil; it's just an example). Obviously the default behavior of this form is that upon opening, an input dialog will prompt for the "[@id]" value. But what I would l...
Hi there, I'm using DoCmd.Maximize On the Open event of a "split-form", so that it the form fills the screen when opened. Unfortunately, this seems to remove the scroll bars for the form, which I have set in the form's properties. There is a requirement for the scrolls as info does extend beyond the screens real estate. Cant seem to f...
Hi, Would anybody know how to determine what a forms data entry mode is from within VB. The reason for doing this is to be able to hide/show controls depending on whether or not the user is adding or editing records eg: if Me.DataEntry = New then Me.comboBoxForEdits.Visible = false end if Thanks in advance for any help Cheers Noel...
Hi there, As the title suggests, I'm trying to get the caption of the associated label for form controls eg: Dim ctl As Control Dim errMess As String errMess = "" For Each ctl In frm With ctl If (ctl.Tag = "*") Then errMess = errMess & ctl.Caption & vbNewLine End If End If End With...