Search results

Thanks Jack, You make perfect sense, why didn't I think of this , I do the exact same thing with the standard rate of chemical, the brain just tries to complicate things for you sometimes, quite often there is an easy solution.....Do you think the growers in the US would need a simple...

Thanks Mile-o-Phile for your answer, I will investigate using make-tables. Hi Jack, how are you? I'm well, nice to hear from you. Basically what Jack is saying about data changing and calculations changing is the reason why I'm trying to do what I'm doing. The scenario is a chemical spray...

I have a query based on 4 different tables that gathers bits from each then performs some calculations (I inserted the totals line and have summed one of the fields) What I want to do and don't seem to be able to is use this query to append the summed column and a few others into a new table...

Hi there, Does anyone know anything about distributing access programs that have been packaged with the Package/Deploy wizard with runtime to Mac computers? Is it possible? Will my program work? As I don't have a mac I can't test it to find out! Thankyou for any info Cheers, Rachael

Has anyone had any experience with using the Package Deploy wizard to install DB's onto computers running Windows ME? I use the PDW and don't have any problems with the PDW installation program but am now getting clients with Windows ME unable to install because the installation process copies...

Thanks Guys, I do have the module called the same name so I reckon that will be the problem. Cheers, Rachael

I have found this piece of code by searching the forum. On putting it in my data base and doing all the right things I get a message when I compile stating that Access wants a procedure not a module and highlights the line of code "Call HideIt("YourFormNameHere")" Below is a copy of the code...

Brad, thanks, you legend!, email me your address, we might be neighbors!! Do you prefer red or white, sweet or dry? Cheers, Rachael

Hi Brad, thanks for your reply. Where do I put this stuff, in the OnOpen of my splash screen? This method seems heaps easier than what I was trying to do. Would it be too much trouble to ask for the code in a bit more detail? I would like to be sure I'm doing the right thing! Thank you lots...

Hi, I was wondering if someone could tell me the easiest (and/or best) method to check if a table exists in a backend database. What I am wanting to do is add to the OnOpen procedure of my splash screen in the frontend a routine that checks if a particular table exists in the backend and if it...

Thanks Brad, sounds easy when you put it like that , I was thinking it would be much more complicated. I see you're a fellow Victorian and VB fan, Victoria Bitter that is, not a bad brew!! Once again thanks for the solution Cheers, Rachael

I was wondering if someone could point me in the right direction on figuring out how to add a new table to a backend database and relink to the frontend via code. I need to be able to do this from the frontend as I have distributed the f/e and b/e. Thankyou Rachael

Hi All, How are table properties modified in code in a table that exists in a backend database. I want to change a field property from not indexed to indexed (no duplicates) Thankyou to all repliers Rachael

I got this bit of code from the Relink on startup module that is found in the soutions database and can also be found in the knowledge base. Public Function Browse() On Error GoTo Err_Browse Dim strFilename As String Dim oDialog As Object Set oDialog =...

Well Jack, I don't know about having 'the gift', I think it's pure arse actually, but anyway the code does seem to work so far, today I have installed the new frontend on several different computers and it is working fine. So, don't ask me, sometimes things just go your way. Perhaps having less...

By the way, I forgot to mention that I used the common dialog control, thought this would be useful for others in the future who have the same problem and find this post, I know I use the search function all the time and only post after lots of searching. Cheers, Rachael

Hi guys, I am impressed today to see that my post has sparked some interest. Since yesterday I have come up with a solution that seems to be working, now, I don't know how technically sound it is but so far so good. Here's what I did: I created an unbound field on a form and used the...

Thankyou so much for your help Jack, I haven't tried this yet but will let you know how I get on through the day some time. Thankyou. Rachael

Jack, Thanks, I will leave you alone for the night after this post, no need to reply today, but while you are dreaming about my problem, I just thought I would give you a little background on why I'm trying to do what I'm trying to do. My database tracks student records ( I work for an...

Jack, Its only 2.51 in the afternoon here, so will look forward to your response over the weekend. Enjoy your book! Back to the problem, deleting the tables form the frontend doesn't activate the relinking code, it simply means the database doesn't work 'cos it can't find the table. My...