Search results

One thing you could consider is making a master ID field for each of the tables in the central backend. When you copy the data from the user backends to the central backend you keep their auto-generated number but also store the user name or id. This allows you to check if a particular user has...

You should be able to set a default value of the parameter in your stored procedure. Something like this: @Parameter as Int = 0 You should be able to use a date as a parameter although dates are handled differently in Access and SQL. I find that I need to convert it into something that I can...

I am not sure what you refer to Galaxiom. I found another way that was supposed to work with inputting parameters however I could not get it to work and the thread where I found it ended without a working solution. If you could post a simple example I would appreciate it. It is always good to...

Thank you Minty. With a slight change to the way the stored procedure worked, mainly related to converting the string values coming from Access to date and such, the whole thing works brilliantly. I ended up with this result: Set Cn = New ADODB.Connection Cn.Open = "Performance leadership"...

Good morning Following concerns about someone accidentally deleting the access database we have been using to crunch performance numbers, I have successfully moved the data on to an SQL server :D While the database works as it is, several of the queries are running extremely slow. I therefore...

you can always use dmax+1 to get the next higher number for the invoice in your invoice table.

If you are absolutely sure they all start from row 8, you can delete the first 7 rows through vba and then import the entire sheet. For deleting the rows you don't need, you can find some inspiration here. For the import bit you can use the DoCmd.TransferSpreadsheet Method

Have you considered having the program send an e-mail to the supervisor? That way they don't need to keep the program open. I seem to remember seeing an option for automatically collecting answers via e-mail but I have not explored that possibility.

Cascade deletes are quite dangerous. If you only have those two tables it might not matter much but when you add the next table, things will also disappear from there or they will stop working. I have no idea why this is occurring but I would recommend that you re-think the reason for having...

I have used the technique from here http://www.granite.ab.ca/access/progressbar.htm It relies on vba but you can probably use it from a macro as well with some modifications.

This is how I am sending with an excel file. It can be used for a single e-mail or called for each of the e-mails you wish to send. There is a small loop that enables it to go through a query and add all the receipients from a pre-defined list. You can use the same technique as it scales with...

You nearly gave the answer yourself. Since you have a subreport able to generate a specific page on you main report, you should be able to have the subreport generate the page you want by providing it with the required ID. This you should be able to get from the table where you also store the...

Jass7869 the method CJ_London refers top is able to import a spreadsheet into a table in your database. From that import table you can do your checks and transform it into something that fits your existing table. From a user perspective it will just be a button but there needs to be a whole lot...

So I have been playing around with this challenge for a while now. There appears to be two important things in play. In one area you need to look at childnodes to get your data read correctly. In the other area you need to look at the attribute of the childnodes. This is the method I ended up...

I am not sure you can use it but access has an xml parser built in. It requires the right reference to be activated but once done it works fine. What you are looking for has to do with either childnodes or attribute value if I remember correctly. I don't have any examples as I am struggling to...

I tend to use a permanent temporary table instead of creating and deleting it all the time. Once I finish with the table I wipe the data so its ready for the next time. For me it is easier than creating and deleting and as far as I understand it is faster as well.

This is nice. After activating the reference for active x I just needed to change two lines to make it work: Dim XMLHttpRequest As XMLHTTP Set XMLHttpRequest = New MSXML2.XMLHTTP was replaced by Dim XMLHttpRequest As Object Set XMLHttpRequest = CreateObject("MSXML2.XMLHTTP")

thanks for the reference spikepl I think I can see how it was done. I will need to try it out tonight and see how it works.

I have been dabbling in excel to get data from an online database however I would like it to come straight into access instead of coming through excel. In excel it is quite easy using a web query however I have not been able to find anything that can do the same in access. Is it even possible...

good morning: how can i help you? that could be a reason.