Search results
-
P
Question Removing ribbon etc...
Hi all, I have created a database programme with A2007 but I would like to deploy the programme elsewhere and I don't want the A2007 ribbon appearing. Is there a way where I can deploy and have the users see only what s the programme and not the ribbon/tools etc. ? :banghead: Thanks -
P
Automate the import of Excel Files into Access 97 Table
Hi all, I am trying to automate the import of a number of excel files, which are all housed in the same folder, into an Access 97 table. (see code below) However the line : sFile = Dir("C:\1 NoN EU MEMBERS 2015\IndiLists", "*.xls") is highlighted in yellow when I try to run. It gives a...- pipmic
- Thread
- Replies: 1
- Forum: Modules & VBA
-
P
Extra validation
I have the following: but I get a compile error Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.PV_Number & "" = "" Then MsgBox "You must make an entry in the ID field!" Me.PV_Number.SetFocus Cancel = True ElseIf Not (Me.PV_Number Like "[PpRr]*") Then...- pipmic
- Post #6
- Forum: Modules & VBA
-
P
Extra validation
Was hoping if someone could get me started off with the coding!- pipmic
- Post #3
- Forum: Modules & VBA
-
P
Extra validation
Hi, I am trying to add extra validation in a sample db (done in A97 (converted to A2003)see attached. I am attempting the following: Please not that the db has existing validation which I would like to keep (or change if advised) Conditions: 1. Input into field “ID” must start with the...- pipmic
- Thread
- Replies: 5
- Forum: Modules & VBA
-
P
Distinguishing data
Hi all, I am having difficulty distinguishing between two same surnamed individuals. I am providing my sample which provides my provides my problem. I have two same surnamed individuals but when I highlight them in the form the same data appears in the subform. Grateful for assistance:banghead: