Recent content by gilly
-
G
Table locked when trying to update via code called by a form
Cracked it Someone suggested to me that I should SQL statements instead of calling Access-built queries, but this didn't help. Instead of deleting and rebuilding the tables via an Access make-table query I used queries to delete the data and append the new data into them. -
G
Table locked when trying to update via code called by a form
I have created links to the paradox data files in Access and then reference these linked tables in the query using just a standard make table query syntax. -
G
Table locked when trying to update via code called by a form
:eek: :eek: :eek: :eek: :eek: :confused: :confused: :confused: I am trying to update a database table via a command button on the main form, that uses tabbed sub forms. The database gets its data from paradox data tables copied our company's third-party software. These table files are... -
G
Run-time error 3211 - New User
I have had a similar problem and found a couple of ways to tell access to pause via a line script placed at the top of your module under the Option Explicit. Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Then type for example "sleep (5000)" to pause for 5 seconds...- gilly
- Post #2
- Forum: Modules & VBA
-
G
Using week format within an append query
Hello, I have written an append query to import data from a linked CSV file into a table in an Access Db in week and month ofrmat. When I try to import the data in using only the month format (using 'exp:format(field2, "mm yyyy")') it works fine but when I have added onto to the query to add... -
G
creating a query to calculate orders delivered ontime
Hello, I am trying to create a query that will show me the % of orders delivered ontime. The problem I have is that orders can be invoiced more than once. To combat this I have tried to calculate the total items sent and mark them as ontime or late in one query and then create a second query...