Search results

So I can get the "long date" to display within the query field itself. However, the "long date" is not displayed when using the date field in a user defined field. Is there a way to have the "long date" displayed. I tried using a calculated field in the table that the query references, but...

So I am running a query against a table to return the total number of records within the table, this number changes following data imports. Viewing the table there are 550 records. Running just the query against the table returns a 550 count, but Running the query after associating it with...

Hello all, So it seems simple, but as part of an excel import I use some automated formatting to match my excel to my table structure. Recently I tried to modify it to remove the "periods" in my name field. However, I keep receiving a subscript out of range error. I also receive this error...

Good morning all. I'm trying to copy information from a unbound txt box on a form into my table and I am having trouble with the formatting: table name: tblNewJoinDate Field Name: Last Run Form txtbox name: New Join Date I'm getting a SQL INSERT INTO formatting error message Private Sub...

Good Morning All, I'm getting a "runtime error 9" Sub-script out of range. This hasn't been a problem before when I have used this same formatting code in other applications. The problem occurs in the objXLApp.Selection.Replace What:=".", Replacement:="..", LookAt:=xlPart, _...

Hello all, This is what I am trying to do. Compare two tables. Find associated records in table 1 that do not match records in table 2 and vice versa. Next be able to further filter those results based on a combo box selection. I am trying to do this all in one query. Data is being pulled from...

Hello all, I am having some issues with this error showing up on my forms. I have a calculated field that is the result of 2 queries. The first query gives me the count of assigned and trained personnel and the second query divides the results and displays a percentage. Both of the queries run...

Hello All, Does anyone have an idea on why the following is causing a run time error 1004? Method Range global. objXLApp.Columns("A:A").Select objXLApp.Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...

Hello All, I am in need of some help on this one. I am trying to import a "user selected" excel file into an access table. I have been able to some of what I need using. DoCmd.RunSavedImportExport ("Import-CPIMS-Belt-Report") But this only works on my machine becuase I created the Saved...