Search results

Okay, but to create a form in Access you still have to drag and drop controls onto it. This is exactly the same as in VB isn't it? I imagine with Access, we could make it a .mde to hide the code. And people could even just email the database to each other to start using the system couldn't they...

I have a SQL server back end. This will house all the data and stored procedures. The question is whether to design the front end in visual studio (VB6) or Access VBA. Are there any pros/cons over either choice? I imagine if in Access, the code will still have to run a stored procedure on the...

I upsized my Access db to SQL server and all the tables were automatically linked. Unfortunately, it now asks me for the username and password everytime I open the db and this is usually a distributed application so I don't want users to see this. Is there a way to add the db string in code? I...

I think I just referenced the cells directly. What code are you using?

I'm still lost on this part. I see how you're using variables in your example but your're still typing in the number/calculation before it number1, number 2. You are using an alias rather than a variable aren't you? My calculation is this: IIf (ISNULL(ZI.InvoicesRaised,0)=0, 0, IIf (IIf (ISNULL...

In my Access system, I noticed the performance slow down dramtically recently after adding some extra subqueries to my SQL. There are some tables in this list that could be combined into 1 table by just adding a month identifier column instead but I'm not sure it would cut down on all of my...

...but where in the SQL do you state what the variable is? e.g. in SQL server you do DECLARE @num1 int SET @num1 = 10+45 SELECT @num1 Not sure how to do this in Access SQL?

In SQL server ? Fair enough. I dudn't think you could use variables in Access SQL though ?

I know, it's a complicated calculation but I'm not sure I can do much about it. The problem with SWITCH is that it only evaluates an expression to TRUE and returns a value whereas IF (or IIf) will return a value if TRUE, otherwise it will run the FALSE part of the statement and continue. The...

So to do this I'd need to split the DB and link all the tables through to the SQL back end. How do you then make sure they're of the passthrough variety - are there some properties or something? Maybe it's better just to make an ADP file and change everything to MSDE ?

Just been upsizing an Access DB. It seems to create views and functions for normal select statements and stored procedures are only created for insert or update statements. As fas as a recent DBA told me, he said that views should be used sparingly as they are not very efficient. Is this the...

I had been using some SQL in Access with many IIf statements. I understand the equivalent in SQL is CASE, WHEN, END. However, I'm really stuck with the following: oh..ISNULL used to be Nz as well...

My original Access system had some automation, which added some tables to the DB that were linked to an Excel spreadsheet. These tables were then imported into the permanent tables in my DB. I still need to import data from the spreadsheet to my DB but it is all now split. The DB is on a SQL...

Thanks for that. A few questions though... When you migrate everything to SQL Server (under MSDE) there are 2 options: link tables make ADP file (client server) If you just link the files, where are the queries processed? On the client or at the SQL server end. If you convert to ADP, I assume...

I've converted my DB into an MDE file as I understand this secures all the code and doesn't allow any changes to the database (table structure, queries, etc.). However, when I now view my MDE file, I can still delete queries and change tables. But I cannot view forms in design mode and...

I have designed an Access DB with various forms to display data populated by queries. This runs fairly efficiently when on the same system. As soon as I try to split the DB into a front and back end and place the data part in a network folder location (across a WAN) the performance is incredibly...

I have a Print button on a form, which actually prints off a report for the user. Some of them seem to be trying File-->Print, which actually just prints the form instead of the report and no matter how many times I've told them to use the Print button, they seem incapable of remembering. Is...

Thanks. Also, need to find how to get the filename. Is this contained in a property somewhere?

I would like to change the Application Title to the filename of the Access DB when a form is loaded. Users actually change the Access DB filename every now and then with a month value to show its latest update and would like this to appear at the top. Any ideas? I have a dummy title set as part...

perfect. thanks.