Search results

Hi, Been away from Access for a long time so please bear with me. I have a pop-up form which allows the user to open a main form based upon different queries. The problem I'm having is the main form is opening but showing all records and not filtered. If for example the user selects all records...

Hi, I have a problem where 50% of our users are using Outlook 2K and he others Outlook 2003 hence different libraries. If I remove the references to the 2K library the 2K users are fine but the 2K3 users are not and vice versa. Does anyone know of a way to keep both sets of users happy ? I know...

Hi All, I have a db that sits on a server which primary use is to just sit there spliting information. No users access the db directly. The problem I'm having at the moment is when I try and open the db from my PC whilst it is still open on the server I get the error message "Unable To Lock...

Hi All, I'm having problems with MkDir. I have a command button which will create a network folder based on field values on a form. ie G:\NPD\FolderName Everything works fine on my pc but it will not work on any of the client pc's. I just keep getting the File/Access Error. If I create the...

I'm trying to return the value of 'Title' from a file property (word, excel etc), but with no luck. Has anyone done this? If so I would be grateful for any help. Thanks.

Has anyone ever used Access to import XML data. My boss has been told that it is possible but I've never used it. I have searched the forum but there are not many threads on XML. Can anyone offer any advice??

I have a query which exports data as a .txt file. Is there a way of stopping the export if no data is returned from the query, something similar to the report On NoData event ???

Hi, I am using an unbound frame to view linked images. When linking to .bmp or .jpg etc I just select the file and then through code inserts it into my frame. Whenever I select an Autocad (.dwg) file Autocad opens up and I have to close it to insert the file which is taking ages to do. Is there...

Hi all, I developed a database which stores the path to an image in a table. I use the common dialog box to allow the user to select an image from a network drive which then inserts the file name into the table. On my pc this works fine and on about 50% of the users pc' it works fine but the...

Hi all, I was wondering if anyone has ever used this powerup from Unisoft and what are the pros & cons. I would be interested to know if anyone has used any alternatives ( If there are any). Thanks in advance. Kev.

Hi all, I have a routine ,part of it is to update a field value in the current record. I am using with rst .Edit .Fields("MyField") = "My Value" .Update .Close etc,etc, The problem is that instead of updating the...

Hi, There is probably an easy answer to this but here goes.. I have a db that logs all calls to our IT dept. I want to mail a report each week showing all calls not resolved. I'm stuck trying to decide where is best to put the code for the event. If the db was open 24/7 then I could use the on...

Hi, I have a form in which a user will enter data for a tool and the product that the tool will produce. On another form I have a combo box which contols a subform so that when the user chooses a product from the list the sub from shows all the tools required for the process(a bit like a...

Hi, This problem seems simple but I cannot get my head around it. I have created my own auto number routine which works fine(the reason I did this is because I was fed up of not being able to reset the inbuilt autonumber when you delete a record).When a new record is created I want to be able to...

Hi, I posted a topic a few days ago but I didn't explain it very well. The problem is that I have a query based on 4 tables. Each table has 14 records. When the query is run I would expect it to show the data I need in 14 records in the query.Instead it is showing 38016 records in the query. Can...

Hi, I am currently working an a database that was originally developed by someone else. It is a bit of a complicated process but I'll explain the best I can. Data is exported to an export folder from a third party program once a day.In the database there is a macro constantly running waiting for...