Search results

No offence taken :) we are all here for the better cause you can identify the IP address within Access VBA. Im not sure about the port but if the port on the other PC is open, then i cant see any real issues especially if there is a re route in the router for application re-direct. you could...

No dude, not something 'wrong' Double posting i.e. same post on more than one thread even if it's on a different forum is viewed with a dim light. Let's say it was seen here and someone spent time o look up code and work a solution only to find someone else has already done it is a tad...

Why don't you use a 'Save As' dialog from within Access and save all the trouble? Cheers

This is a double post on UA! I won't post the link in case I get banned here too.......... Nigel

Hi you can pass the control name to the function and call the function on the key up event Cheers Nigel

Hi Jon Why don't you make the header match your front page? It's looks well but disproportional as they are both different :) Nigel

Hi, it is a difficult one because of you being a college student at the minute too. with you just saying £5000 might be a shock so i would break it down to weeks days hours- lets say to settle in your mind £6500 6500 / 25 per hour = 260 hours or 6.5 weeks @ 40 hours per week. if it was...

I dont know though... If the Company specifically asked the OP to develop the database, then they do own it even if the OP developed this mostly at home. If the OP suggested that it could be done 'out of hours' in personal time and made it clear, they i wouldnt think that the Company would own...

have you been to Coventry? lol Seriously, i belive it might be something to do with a Civil War where AWOL soldiers or captives were sent as there might have been a strong hold in Coventry and the locals didnt loke it so never spoke to anyone who was 'sent' to Coventry!!! cant be certain but...

Hi, Nz = Null to Zero If the return value is Null or 0 or "" depending on var type, you can declare a return value. Good when you get issue for no record- Dim iTest As Integer Dim sTest As String iTest = Nz(MyForm!txtTestNum, 0) sTest = Nz(MyForm!txtTestText , "") If iTest = 0 Then...

Hi Martin, is the report linked to a query? If so, is there a criteria set on the query? Bear in mind that at the open report call, text2 value is for example- Text2.SetFocus Dim txtdept As String Dim txtdept2 As String txtdept = Text2.Text ' ( value is Accounts ) txtdept2 = "dept=" +...

Hi, Start with a pen & paper. try drawing out the critical paths nad processes you think you want. Then your tables. What you want can be done quite easily. Another thing i have in my appicaltion is to make groups from multiple parts. An Installation for example has the following as standard-...

Sorry i'll post in a minute!

Hi, have you looked at this? http://www.equinemax.com/equinesoftware/smallbusiness I part made a program similar for my wife a few years ago but i havent done anything on it for a while. I'll read through your post a little in depth later and reply to some of your answers :) Cheers nidge

Hi, Access can do this. I have made ( and still in the process of ) an in depth system. Here is what mine covers- customers Suppliers Purchase Orders Projects Quotes Revisions Job Cards workshop Resources Scheduling Cost Analysis Invoicing Extras i have added recently, Gannt chart...

Hi, 1 table would be ok for the customers with a separate table for quotes. Think of it like 1 customer can have many quotes so a 1 to many relationship would be required. Then maybe, another table for quote revisions and, because 1 quote can have many revisions, a 1 to Many relationship there...

But splitting the back end will not take away the fact that the Access window is visible, it merely moves the tables to a separate database! The Access window will still be visible when running the 'front end'..... This should hide and show the access window- '-- Constants used by...

hi this is a tricky one. i recently achieved this at work but in excel where my pop up always appeared central to the dual monitors. i'll have to dig the code out when i get there tomorrow :) cheers nidge

Hi, i hadent checked it. Maybe your images are too big? i think they have to be 16 x 16 for a small ribbon icon but its worth checking. It will be a simple thing only :) cheers Nidge

Is this a school project? Why wold you have a code routine tht you dont understand? It is looking for values in in a table called Variables using DLookup. Each Variable set at the 'Dim' section is set at DLookup by collecting the value of 'Value1' based on the criteria of the parameter...