Search results

When I say difficulty Im referencing complex vba not sql.

I've been supporting MS access databases for about (3) years. I've very proficient at relationships, tables, queries, forms, and have written a lot of code and run some automation tasks. I'm certainly not very good and have difficulty understanding some of the hardest VBA code. I know HTML and...

How do I start the numbering at 1 and not 0? Option Compare Database ' Declaration section Public AutoNumber As Long Function SeqAutoNumber(i As Variant) As Variant SeqAutoNumber = AutoNumber AutoNumber = AutoNumber + 1 End Function

Thanks. It makes sense what about the ones from the tables. MSSyt Objects

Using the exporting method of tables and queries SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Type)=5)); Im seeing various named items that don't show up on the access objects even with all navigation unhidden. For example: Table Name MSysObjects MSysACEs...

How do you get the number to reset back to 0 after you run the query a 2nd time?

I'm compiling a solution in access to consolidate data from multiple infrastructure repositories that contain information about the applications where we have NPPI data. Anyone know of any good resources to gain an understanding of infrastructure at a high level to do this. I need to get...

What was the problem?

1.You can create the target table [hits] in a number format 2.You can add text box on the form naming it [hits] and make it not visible or visible. 3. Your code should look something like this when added to the On Click Event: Private Sub Command3_Click() If IsNull(Me!Hits) Then...

DELETE Query is always helpful for this process: DELETE TABLENAME.* FROM TABLENAME;

So the final looks like this: Option Compare Database Private Sub cmdClear_Click() Me.subProductivtyReport.Form.RecordSource = "Select * From subProductivity " Me.subProductivtyReport.Requery cboReviewer = "" txtFrom = "" txtTo = "" cboStatus = "" cboVendor = "" cboRole = ""...

Here is a sample with no real data.

Any examples anywhere?

Hello and Good Morning, I posted a few weeks ago about this and got some great feedback so wanted to share the situation further. I had a client of mine who approached me on a project that they are able to accomplish in MS Excel. They are looking to use MS Access for it as well however after...

Also found this: sNum_IMA = "MISS" sNum_HPV = "MISS" bFS_IMA = False bFS_HPV = False

Thanks I checked everywhere. I found that some were declared like as follows: Dim sNum_IMA As String ' Numerator in IMA CIMANF textbox Dim sNum_HPV As String ' Numerator in HPV CHPVNF textbox oFrm![CIMANF] = sNum_IMA ' load numerator...

Maybe something like this: Months: DateDiff("m",[DateFieldName],[End Date]) Change "m" to "d" for days Put +1 or -1 at end for day adjustment of calculation

cant find what bFS_IMA and vFS_HPV is linked to on the form. there is no field. Doesnt make sense.

If [internal] = "IMA" Then If (CIMA1NF = True) And (CIMA2NF = True) Then sNum_IMA = "HIT" bFS_IMA = True ' set File Status flag End If ' (CIMA1NF = True) And If CHPVflag = True Then sNum_HPV = "HIT"...

Responsible for making some changes to a database and having difficulty finding reference for the below. Cant find the field which corresponds to the Boolean Any ideas: Dim bFS_IMA As Boolean ' IMA File Status Dim bFS_HPV As Boolean ' HPV File Status Code...