Search results

done that to both front and back end

It's not in the navigation pane where I'm not seeing them. It's when I click linked table manager

i don't know how to do it. are you suggesting writing code? the link is there as i can display the contents in the FE and if I hover my mouse over the table in nav pane I can see the link.

On the external tab the only access to click is export. There is one under new data source which i've tried already. I tried it on one file and it creates a linked table with a suffix of one. THat doesn't appear when I try the normal method either

Not unless I've hidden by mistake. It worked a week ago. But I'll double check

no they were originally linked (and still are), I just can't see them to relink

Yes they do and if I hover my mouse over them I can see the link. If I open the link manager it shows me nothing. If I select all (from nothing) and click the re link box it throws up a window so I can get the location of the linked table (if I knew it). This was working a few days ago as I put...

I'm using access 2016 btw

I'm working on a small database that has linked tables to effectively 2 back ends I went into the link table manager to not only check what's linked to what but to relink everything as well Lo and behold the list of linked tables is empty I can display the contents of each table so they are...

Thanks to everyone's input. I went down the MSysQueries and Objects route and got what I was after

Thanks to everyone. I've used the long hand method!

Yes I am talking about the wizard *I hid that fact in the title!!). I have a date and time field for example. The report has a control that just about manages to get the month and a "/" in.

for everyone else that's suggested things I will take a look at your advice but at the minute I have to finish the current project before I start investigating whether or not the other queries are using the to and from dates correctly

you may well be right. I actually didn't have the + 1 and it wasn't working if the date was equal to the to_date. After some investigation i noticed the date had the time in it as well so I had to add the + 1 in

As per title I'm producing a fairly simple report but the width of the controls looks pretty random. Fields with few characters seem to have large widths and others are truncated as the width is far too small. I know I can go in and change the control dimensions but it seems a bit painful. Am I...

thanks I'll take a look

I am looking at an access database that uses to and from controls on the main form to control what is displayed in other forms and reports etc. I there an easy way to see which queries uses these controls as their criteria. So I've created a query using the following criteria...

Thanks to everyone for the help. Appreciate it

i've got something like that I've got strParentForm= Me.Parent.Name and then i use If Forms(strParentForm)![strtemplate] <> "Sale" Then

I've inherited an access database. There is at least one instance where a subform is used on 2 different forms. Let's call them form1 and form2. The problem is that code in an event procedure (after update) assumes that the form is form1. The problem is that this event procedure is now...