Search results

The simplest way is usually the best lol. There is no 'right or wrong' way. Its whatever works and delivers the result Thanks

Hey Can you copy your MoveText routine to here? As it is responsible for calling and by the looks of it, makes the scrolling work, i suspect the error is happening there Thanks

hi, probably really dumb but cant you just count the records and minus one in lieu of the last record? Dcount = whatever - 1 that or call a query and count that instead thanks

and........ what happens in the MoveText routine? thanks

hi are you doing this in access? if so, you can enter the accounts details on the bottom of the report in design view. if you want it programatically, you should create a query that collects the invoice information and collect the accounts detail in the same query. you can then distribute the...

Hi Auto exec is just for running routines when the application opens. What isn't working? Thanks

Hi, if it was me, i'd make the function more flexible. you shouldn't hard code email addresses and notifications- Public Function fDOBNotices(strTo As String, strSubject As String, strBody As String) As Boolean Dim db As DAO.Database, rs As DAO.Recordset Dim strTo As String, strSubject...

Hi its not as hard as you think. If you want to send me your db's, i'll do it for you, comment what i have done and send it back. you can email me nigel at acccis dot co dot uk Cheers nigel

Hi yesh this could be done with a DAO recordset call. You can connect to another database quite easily too. the process- make a query based on CARREG. this should be the table holding the information with the 'CRITERIA' set to your forms car reg field. When the query opens, it gets the car reg...

Hi I use sagekey and have done for quite some time. If you are updating a front end, why is there an issue? Sagekey will be in the front end thus be replaced with the new front end. I take use of this by changing option codes for major updates. The option codes are part of the licencing so if a...

Hey Post your code. I wouldn't necessarily make the variable public unless its required elsewhere. Remember that it will hold data unless its emptied. I would change the called routine to something like sub MyOutsideRoutine(sString As String) Or whatever the variable needs to be. Then, from...

well, here is what i would do. combine into one routine- Sub YouSure(chkBox As Integer) Dim lReply As Long lReply = MsgBox("Clearing this checkbox will clear all information under it." & _ " Are you sure you want to do this?", vbYesNo, "Are You Sure?") Select Case lReply Case vbYes...

Hi, i see that you use the term "other tradesmen". What trade is you are in? im in shopfitting and i too looked at something. i was 60ish% into an application but ditched it. have you considered Clarity by Touch systems? thats why i ditched my app. for the money, well worth it believe me :)...

Hey glad to be of help. Give me a shout if you need any help implementing this Thanks Nigel

Hi I totally get what you're saying. I cant see the 'real' benefit however. To store variables in a table. you would still need to declare them to use them. To me, that kinda reads that more code would be required...... If you can provide a smaple of what you are trying to achieve, i will do...

Hi, ive not been here for a while. nonetheless, ive gained a lot, if not most of programming experience from this site. Ive read through this thread and there is a lot of im not doing this im not doing that its not fair etc etc etc The fact is, the site need funding like every other aspect...

Hi Peter Have you googled 'vb to get hard drive serial number'? Cheers

Hi Ive done it before and it wasn't that bad............ My setup I made a button to click offline. This toggled my back end. I setup two routines in vba to connect to different back ends. I set a field in a settings table to tell the FE which BE to look at. So, When I went 'offline', a...

Hmmmmmmm There is 'a way' of getting the password but what's to say its not actually your DB and you just want to break in? I don't think anyone here would give you a method of breaking in, I may be wrong. If its actually yours, and its crucial that you get access, then you may be happy to...

Hi, this is pretty simple. Create a global Variable- Public strGblUser As String set the variable upon correct login strGblUser = Me.cboEmployee.value Now you can call back the the user any time by calling the variable. Simple :) Nigel