Search results

I am trying to solve a problem with and access application that I didn't develope (great fun :( ) It has an access FE and a SQL Server BE. The main problem is one of write conflicts on a particular table. If I add a new record or try and edit an old one it comes up with the write conflict...

how about using chdir? the code might be looking for FBAKARA.MSV in the KEVA directory. Maybe either copy FBAKARA.MSV to the KEVA directory or use ChDir("C:\Program Files\BCCLTD\") before the call shell line? Sorry I haven't had time to test this so I could be completely wrong! :o

thanks for the comments guys. One of the main problems at the moment I think is the fact that many queries use joins between the tables in the two BEs. I was hoping that I could upsize each of the BEs to SQL one at a time and (at least!) not have any decrease in performance, and then tweak the...

I have an access implementation separated into a FE and two BEs whose tables are linked in the FE. I have been considering upgrading the BEs from Access to SQL Server 2000 and from what I have read and tried this seems to be a fairly straighforward task. However I have tried doing this using...

this is the method: DoCmd.OutputTo acOutputQuery, stDocName, acFormatXLS, , True I have never used the transferspreadsheet method. What would be the equivalent line using it?

folks, I'm trying to export a query to excel and it is mostly successful. The problem is that certain fields containing multiple words appear in the column and the whole column appears to be right justified, ie only the last 10 characters are displayed depending on column width. I can't change...

I am looking at the possibility of my fe/be database being used over a VPN in the near future so I am interested in this discussion. When you say 'make sure all the processing is done at the server' what exactly do you mean? Are you suggesting that queries should be on the server and only...

It seems so simple now... :rolleyes: thanks for your help

I've already tried a few variations on that to no avail. heres an example of what I am looking for: empnum start finish 001 02/04/2003 04/04/2003 001 01/04/2004 06/04/2004 001 14/04/2004 16/04/2004 001 19/04/2004 20/04/2004 001 28/04/2004 30/04/2004 I want the query to give me the first...

I have a database containing absence information for employees. The table has a number of fields including employee_num, FromDate, ToDate. there are usually a number of records per employee. I want to set up a query to pick out an employees records that overlap: i.e. the fromdate of one record...

Hi Folks, I know this is a tricky area but none of the previous posts have covered what I am looking for. I am using DoCmd.OutputTo to export my report to RTF and autostart it in word. Is there a way I can apply a custom word template (a .dot file containing a custom header among other things)...

I had hoped I wouldn't have to resort to that :(

Hi, I having a bit of trouble with my date fields in a table. I want the user to be able to change a date to either another date or blank through a form interface. Access won't allow me take a blank string from a text box and put it into a date field in the table. anyone got any ideas thanks Dave

I've had a look at mySQL - it looks like it could be a very cost effective solution. the company in question has a bit of a microsoft fetish so I might be stuck with microsoft products :(. Thanks for all the replies though, esp Pat - you've been a great help Dave

Thanks Pat, that has answered all of my questions! I'm going see how it copes with the increased load first before I jump in with any new BE. (All users have a local copy of the the FE BTW) I've been careful about table/col names so that shouldn't be a problem. I would be more worried about...

Folks, I appreciate any experience/advice on this one. I have a MS access 2002 database system with a FE/BE combination. There are about 100 forms, 400 queries, 50 reports on the FE, and some 30,000 records in different tables on the BE which resides on a server. Currently there are 12-14 users...

Maybe I haven't understood your problem but I think a its just a simply query such as: SELECT * FROM tbl_dams WHERE tbl_dams.EarTagNumber = [dams ear tag number from input] ??

Why are you using the dams table at all? All the info is already in the herd table and if every entry in the dams table is also in the herd table you have redundant data. You simply have to set up a query that looks for the dams tag no in the herds table...

No thats not it. Maybe I have explained it badly. MyFunction() returns a value and I want to use that value to identify a field in a table. i.e. if I have a table with three fields a,b,c I want MyFunction to return one of those from an unrelated calculation so that my Query (SELECT...

Hi, I am trying to use code in a query to determine which fieldname to select: Select Table1.[MyFunction] From Table1 Its isn't working and I haven't been able to find any past postings on the topic to help me. It is obviously something with the syntax (I know the function works if I use in a...