Search results for query: *

OH the front ends are running on access 2003 and 2010.

HI dhookom The info on the slow VPN came from the net, if it's out of date or in correct please let me know. I just want to the best solution I can, I'm open to any ideas. As for SQL I will be mirgrating the back end to SQL , there seams to be a few to choose from SQL, SQL Express, My Sql...

HI Everyone ,Just to clarify the remote location will be adding,updating and searching records on all computers located there. It looks like a VPN Connection would be very slow to unusable from what I have seen. Has anyone tried having a server at each location and having them sync to each...

Hello every one I currently have an access 2003 application split into front and back end. The back end sits on a local computer and is shared with 9 front end computers. we want to now access the back end from a separate location over the internet to 4 computers running the front end I'm...

The data is all coming from the table "purchaseList" The name of the main form is "SF-Main" When I run debug the correct value shows untill I fill the subformwindow up once they scroll past the bottom of the screen the debug value turns to 0

Hi I'm calling it form the afterupdate event in the itemnum text box on the main form I will be adding other calcuations and code as I go to the calcinvoice function The data I need is already in the open subform so it seemed more effiect to get it from there then have access look it up...

I just added this so all I had to send before was what I sent I added second Sum textbox to my subform footer PLTax1Total Public Function CalcInvoice() If Forms![SF-Main]![Tax1Check] = True Then Forms![SF-Main]![Tax1Calc] = Forms![SF-Main]![sbfwindow]![PLTax1Total] *...

my apologies I must have deleted the bracket when I posted the code as it's in my code your solution does work ,but I still need to access subform fields for for some VBA calculations and once I get past the bottomof the display window I can no longer access the fields,they report as 0

on the subform footer I have a text box called Plsubtotal in the control source for that text box I have =sum([price]) onthe main form I have A text box ItemNum in it;s afterupdate event I add a new record that has a discription and a price. requery the subform and update the...

HI Every One I'm having an odd ocurance with a subform On the main form I have a field that you enter in an item number. The item discription and cost are added to the subform table and is requeryed so the new item is displayed . In the subform footer I have a field doing a sum on the cost...

HI NiceArms I'm having a simlar problem, did you find a solution?

Hello Everyone I'm atempting to trap the + - and . keys for special use on specific form I can trap the F9 using VBKeyF9 But I'm having trouble trapping the +-. keys. I have search about for the proper keycode for those keys and have found several differnt codes for each one but none seem to...

HI Alve Thanks for the advice I whipped up my own verison based on your code and it works great.

Hello Everyone I'm trying to use the Autonumber Field type in a table to autogenerate a number but without adding a new record. only the autonumber field is in the table. I know it dosn't really work that way. but that Idea is what I'm trying to acomplish. I was trying to stay away from +1 to...

Hello I'm using Access 2003 and have a shortcut menu bar that does not work when I use it on a subform (displays the default menu) but works fine if it's the main form. I found some information that if your using access 2007 with a 2003 database that it has issues with the shortcut menu and a...

HI dhookom You are Quite right I was mixing up a subform in datasheet view with a list box. Busy working away with a listbox and trying to get to act like datasheet view. thanks

Hello I was wondering if any one could point me in the right direction on how I might be able to make colmns in datasheet view dragable bigger or smaller like in excel. thanks

I got this working by running the SQL in code Thanks for everyones Help

Hello lameid and dhookom Thanks for all your advice. I have gone with the Sql in code and it seams to work just fine. Your Idea with the single record table may help me with another issue I'm having and I will be giving it a try shortly. You Both have beena great Help

HI lameid I gave that a try but no luck still the same. very frustrating