Search results

After a 5 year hiatus from ms access I find myself back using the tool in anger and struggling with something that would have been very basic back in the day The problem I'm trying to solve for is as follows : I have a two tables - one is cash with a term date and the other is collateral...

Hi there, In my table one field has several codes to relect the fact that on equity can be listed on multiple indecies. It looks like this ;2;5;1;1;GF;1;LX;1;GD;1;SE;1;GB; I have a table which contains all of these codes and a yes no flag. What is the best way of parsing this information...

Hi there, I'm using a passthrough query to get information from sql server. Unfortunatly when I try to append a field to a local access table I get validation errors as the field is blank. The table is set up to allow nulls but I think the sql field has some other type of null init. Ive tryed...

Hi, I am trying to link an access database to sql server but whenever I link or import it it changes datatypes which are decimal and numerical on sql server 2005 to data type text in access. The DBS doesnt want to use float as its numerical data and I dont wanto to have to convert loads of...

hI. I want to connect msaccess to a sql server database using a dns less connection. I dont want each user to have to set up a system DNS as they all should have acceess to the sql server. The problem I have is that using the following code the data types are differnt between the sql server and...

Hi, I am trying to build an analysis tool to assist one of my colleauges. I start with a results tables in my access db with 2 days worth of the data in extatly the same format. I then create a cube in excel with 2 dimensions. One shows a Legal entity -> Ultimate parent -> individual. The...

Hi, Im new to sql server so please forgive me if this question is obvious. Any help is appreciative what I'm trying to do is a recursive look up of child to ultimate parent. The data is structured like so . if I look up child 2-4 I want to return sub Parent 2 child sub Parent...

I have never some across this before but my database keeps throwing a "Too many tables open error" which has taken me a day to get to the bottom of. I believe that the use of a dlookup in one of the queries not cleaning up after itself. The issue I have now is that even importing the tables...

Hi There, I have to manually Import some sql server tables that are hugh and i want to atomate the process. I have some code for attaching DNSless tables but really i need to import them. I tried to run make tables on the attached tables but the performance was dire. Importing the tables proved...

Firstly, i am a sql newbie so apologies if this is an obvious answer I need to joing a table to another but unfortunatly theres no one to one relationship. What I would like to do on the table with mutiple records is is group by the key and sum by amount . I then want the query to select the...

Can anyone reccomend a piece of softwear that will assit me in drawing a schema of an access database. at the moment I'm trying to use the reverse engineer function in viso but its very difficult to master. I cant resize any of the shapes and its difficult add not select queries. Any help isa...

Does anyone know how to do this. I need to pass three numbers to a function in VBA. eg 4,4,6 The function should look at the lowest two numbers and and return the highest. if the lowest two are the same it should return that value. 2,3,6 would return 3 4,4,6 would return 4 Any help is a...

Hi there, it must be friday as I'm drawing a blank. I have a function that passes three integers to the function eg 2, 5, 6,. i need to extract the max eg 6. any ideas?? Many thanks

Below is a table that I want to look up from a query. Basically I want to look up a value (e.g 3.56) and find which PRA it fits in so in this case 3.56 is between 3 and 6 so the value returned is 0.7. Where it gets complacted is that the 3.56 is generated on the fly in the query. Can I use a...

I know that this could open a can of worms but is the above statement true. I have always avoided using delet and append due to database bloat. I know its more difficult to set the field types in a make table query but it means that the database doesn’t need to be compacted nearly as much as...

i have just taken over I have just taken over some database which have a load of tables and queries that I suspect are no longer requirer. Is there anyway to see when a table or query was last USED in a database?? Any help is appreciated

As part of my job I am constantly comparing files from a production environment against those from a UAT environment. The checks are generally the generic before I reconcile the monetary values I check that the static data population is the same. Basically I import the files into access and then...

Hi there, I'm trying to put in place a workgroup and I'm struggling with it at the moment. I created a seperate workgroup and have a command line short cut to it. When I try to add a user to the admin group permissions it works fine except that I can't open any of the forms in design mode. It...

Does anyone know if its possible to save screen prints in a table?

Hi there. does anyone know how if there is an excel addin that allows me to create an input form in excel. Im new to excel coding and need to build a form asap. Many thanks in advance