That syntax won't work and that really is not the way to go anyway.
Try setting up a cursor (Google sql cursor for details). That will keep looping through the recordset until it is complete.
Krandor
Last Activity: Jun 19 '09, 09:13 PM
Joined: Aug 13 '08
Location:
-
Let me see if I understand you correctly.
You have data in your Access database that you push to an Access table which is then linked to SQL Server table. This table is the one that is giving you headaches.
I’ve been doing Access/SQL Server combinations since ’94 (yes I’m ancient). In all that time, I have seen very few instances where it was better to do the processing on the Access side rather than the SQL Server...Leave a comment:
-
I agree with Denburt.
Try to insert the data into a table with no constraints, no referential integrity and no triggers. If it still doesn't work, you will have at least eliminated a major possiblity.Leave a comment:
-
I agree with Neo. A VBA loop would be a much better solution than creating a macro. I suggested the macro only because it works for people with no VBA programming skills also....Leave a comment:
-
Neo is correct. There is no SQL command for deleting records from more than one table.
That said, it can still be done in Access. Kinda klunky but still doable.
Create and save one delete query for each table you want to purge. Then create a macro that triggers each of the queries.
So when you want to purge all of your tables, just run the macro.
I generally don't like macros but this would...Leave a comment:
-
Here is a start:
Access is easier for newbies. It is possible for someone with almost no database experience to create a simple database application. Unfortunately, those simple applications don't scale well when muliple users are involved.
Access is for small applications with 1 to up to about 10 users connected at the same time. Anything more and it will seriously choke.
MySQL or SQL Server are for...Leave a comment:
-
If your function is not in a module, then it doesn't matter if it is public or not, you will only be able to use it in the form that houses it. to be truly pulic, the function has to reside in a module.Leave a comment:
-
A web page would be the simplest (and actually cheapest) way to do what you want to do.
Remember first that doing it the current way is also costing a lot of money. Every month someone at each of the sites has to make a copy of the data and then someone has to load all that data into the main database. That is a lot of labor that the company is paying for.
A website that is tied to a database can be put up in as little...Leave a comment:
-
Yes. Exactly. Anything that you want to be global to the whole app (including functions and subs) has to be located in a module....Leave a comment:
-
Your global variables lose scope as soon as you go to a different form. They are "global" only to your login form.
You need to create a module and remove the global declarations from your login screen and move them there. Once you do that, your variables will be available to the whole application.Leave a comment:
-
I don't generally use IS NULL or IS NOT NULL because there are instances where you won't get the results you expect. Example: if the record has an empty string ("") that is not a null so if you are testing for null, you will miss it.
I found it is better to do something like this:
Where Len(qryPhysical s.timeelapsed ) > 0
That way you can catch nulls and empty strings....Leave a comment:
-
Make Loginname a label that is not tied to the underlying table. That way you can populate it without affecting the data.
Your command to populate the field will be a little different with a label. You have to use Loginname.Capti on instead of just LoginName. Otherwise, everything else will be the same.Leave a comment:
-
Create a query that has the data you need on the report. Put your date range in the query and save it. Tie the report to the query.Leave a comment:
-
You weren't very clear as to what you wanted but I'll give it a try.
If you want the amount of the opening balance for today, then you will need something like this:
SELECT Opening_Balance FROM tbl_Savings WHERE Date = (SELECT Max(Date) FROM tbl_Savings)
That will give you the most current balance.
By the way, I think date may be a reserved word. If so it may give you trouble in your coding....Leave a comment:
-
What I am trying to do is this. As part of a software inventory system, I need to identify which pieces of software have been installed on a particular user's computer. That means we need to select the user from one list and then assign all the relevant software packages.
I thought to do this by dynamically creating one checkbox for each software package and then handling the updating of the relevant table via code.
...Leave a comment:
-
The string variable has a 2 gig limitation. So if your file is 2 gigs +, there is your overflow problem.
I'm a little rusty on the exact syntax, but there is a way to input part of the file beginning at a set point (at character 1,000,000 for example). If all you want is the last bit, there is no point in sucking in the entire file into your variable.
You are pretty close using the LOF so I would Google on LOF Input...Leave a comment:
-
It worked but so far not exactly like I expected. What I wanted was for the user to open the screen and have all the controls created on the fly.
What I am getting is an error message that says Controls can only be created while in design mode. Here is the test code I was using.
...Code:Dim MyForm As Form, MyControl As Control 'Set MyForm = CreateForm() Set MyControl = CreateControl(Me.Name, 106) MyControl.Width
Leave a comment:
-
Awesome. That was just what I needed.
Thanks.Leave a comment:
-
Base the report on a query. Within the query make those dates as the parameters and then save the query.
That's it.Leave a comment:
-
Can Access Create Controls At Runtime?
I have a screen where I will need a LOT of checkboxes. The number I will need is based on how many records in the table - currently 194 but certain to grow larger in the future.
Can I create all these checkboxes at runtime? I know that in classic Visual Basic this was possible. But can it be done in Access? I have Access 2003.
I realize that creating controls at runtime slows down the app. This is not a high volume...
No activity results to display
Leave a comment: