* in the name of a table and form

[jmersing]

I inhertited a database that has asterisks as the first character in many of the tables, forms and report names. I'm not familliar with this practice. Can someone explain it?

 

[Norie]

I've not seen anything like that myself and would think it could cause problems.

 

[jmersing]

I figured if anyone knew it it would be you Norie, I thought the same thing (* cause problems). I know the program was written by a guy in his sixties and I think he created it about 10 years ago. I can't get queries to work properly, I don't understand a lot of the code.

The asterisks are used in the code as well ??

 

[Norie]

Can you post an example of the code/queries?

Are errors being generated or unexpected results being returned?

Can you rename the tables etc?

 

[jmersing]

Sure:

Query
SELECT [*Inventory Log].PharmID AS Expr1, [*Inventory Log].AutoNumber AS Expr2, [*Inventory Log].RemoveDate AS Expr3, [*Inventory Log].RemoveReason AS Expr4, [*Inventory Log].MedName AS Expr5, [*Inventory Log].Strength AS Expr6, [*Inventory Log].DEA AS Expr7, [*Inventory Log].QtyRemoved AS Expr8, [*Inventory Log].MedStatus AS Expr9, [*Inventory Log].Tote AS Expr10, [*Inventory Log].MoveDate AS Expr11, [*Inventory Log].NoShow AS Expr12, [*Inventory Log].DestroyedDate AS Expr13
FROM [*Inventory Log]
WHERE ((([*Inventory Log].[NoShow]) Is Null) AND (([*Inventory Log].[DestroyedDate]) Is Null))
ORDER BY [*Inventory Log].AutoNumber;

Code:
Private Sub Med_Name_AfterUpdate()

Me![C#] = (DLookup("[DEA]", "Medications", "[MedName] = Forms![*Inventory Form]![Med Name]"))

If IsNull(DLookup("[Tote]", "TotePic", "[MedName] = Forms![*Inventory Form]![Med Name]")) Then
Me![Tote Num] = 3
Else
Me![Tote Num] = (DLookup("[Tote]", "TotePic", "[MedName] = Forms![*Inventory Form]![Med Name]"))
End If

End Sub

I even found this on the form onclose event :
*Validation.OnClose