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...

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...

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 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)...

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

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...

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...

Hi Folks, this is probably a really easy one but has baffled me for ages now. I have a listbox on a form which for some reason won't allow me select a row. I want to use listbox.column(number) in the listbox double click event and it is only giving me null! any help much appreciated thanks Dave

Hi, I want to to build a query from user selection and to update the contents of a listbox with the results of that query. I can build the query ok but the listbox won't update for me with the list.requery method. any help would be much appreciated Dave

hey folks, I want to develope and access application and distribute it to computers that don't necessarily have the version of access I am working with. As I understand it, the office developer toolkit allow you do this with computers that don't have access installed. my question is will a...