Search results for query: *

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

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...

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...

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...

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...

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

Hello Everyone I have this Query that pulls record between to dates: SELECT Book.BookNumber, Book.DateUpdated, Book.Status FROM Book WHERE (((Book.DateUpdated) Between [Forms]![INS-Export]![EXPLastDate] And [Forms]![INS-Export]![INS-TodayDate] ) AND ((Book.Status)="Sold")); When I export...

I have this query SELECT Book.BookNumber FROM Book WHERE (((Book.DateUpdated) Between [Forms]![INS-Export]![EXPLastDate] And [Forms]![INS-Export]![EXPNow]) AND ((Book.Status)="Sold")); when I run it it works just fine , but when I use this Code in a button on the same form. it asks me to entry...

Good day everyone I'm looking for a way to get acces to wait untill one funtion is finished before moving on to the next I need to use this is a few places, none of them shell out to dos. for example I have some code the compacts and repairs the DB and then I want it to quit after it...

HI Every one I'm look for ideas on how to solve an issue I'm having after I do an update I have 6 computers in differnt locations around the building, some using network printers and some using local printers There is a laser printer and label printer in each location all with diffent...

Hello I'm wondering what the advantages and disadvantages of having more then one back end database thanks for the advice chris

HI I have an unbound Field with a phone number input mask I need to check and see if the field is empty so I can set the cusor postion to the begining. if the field has any thing in it then I don't want to set the cursor postion I have tried various adaptations of the following code with no...

HI I have a table with over 250,000 records in it accessed by several users over the network I'm using a find as you type listbox to view the data When I enter "T" into the textbox it looks at the 250,000 records and brings back every thing starting with "T" when I enter "TH" It looks agian...

HI I'm using a form in Dataview and I want to simulate the way a listbox looks when I click a field all the fields in that line highlight. I only need it allow one line to be selected at time Thanks Chris

Hi Every one I'm trying to achive certin look and functionality on a form. I want to use a checkbox and listbox together. each line in the listbox would have its own checkbox if you check the checkbox on aline the code behind doses stuff with the record ID# in the line next to it,several...

Hello I need to get a list box to automaticlly select the first record when it's populated. any ideas on how to do that would be great aprecatited Thanks Chris

Hello Everyone The issue I'm having is that I need the listbox to narrow the displayed records as I type the letters in the Textbox I can't quite figure out what event in the textbox to put the listbox requery statement into to get it to work right Any Ideas on this would be greatly...

I'm looking for a way to auto create the corect number of tab forms based on information returned from a query. any ideas? thanks chris

Hello all I have a textbox(entryID) that when you enter a number the code in the afterupdate event checks to see if it's valid and adds it to a table At the end of this process I want the cursor to be back in the textbox ready for the next entry. I have tried several ways and locations of the...