Search results for query: *

Thanks for reading and any suggestions you may have. I have a form that will have anywhere from few hundred records, up to about 20,000. For some reason, it will not step through more than 564 records. In troubleshooting, I even put the max records to 500, close the form, and start again. It...

thread700-562429 Hi, I found this thread http://www.tek-tips.com/viewthread.cfm?qid=562429 and it helped me out somewhat. I used the PHV recommended code listed below. Public Function StripNonNumerics(myVar) Dim s As String, i As Long, x As String If Trim(myVar & "") <> "" Then s = ""...

Hi, Thanks for looking at my question. I am importing a spreadsheet into my database that is all text. The import is checked for accuracy and field requirements (not every instance requires the same fields being completed). Part of the check is to verify the total dollar amount is correct in...

1st, thanks for taking the time to look at my question. I am using Access 2010. Trying to transfer a table to Excel. All of the fields must be a text field, left justified, capitalized. This is working fine with the exception of one field name being changed. The field name in the exporting...

I need to do an export to Excel. I have the data being left justified, however the column titles are centered. The titles must be left justified as well. Any idea on to what I need to do to make it happen? I am not able to find any way to do in thru formatting of the field. Have not found a...

I am trying to import a spreadsheet with the following data types. # Carrier Remit Zip Bill To Number 1 FedX 60693 968516528 2 FedX 3 FedX 60693 Each spreadsheet will have 49 fields, can be as few as one or as many as several thousand line items. I...

I have downloaded the FedEx shipping zones from their website. They are based on zip codes, the 1st 3 digits. Example, a shipment going from 55531 to 85226 would be combined to be 555852 which would be a ship zone of 6. I have attached one of the files for you to look at. What I am looking...

Hi, I am trying to determine all possible zip code combinations for the first 3 digits. They then must be combined into a 6 character field used in queries based on zip codes. Ex: 111xx and 765xx would be combined into 111765 and so on thru all possible combinations. The zip codes are used...

I am trying to add a addin for Access 2007, continue to receive the following message - "you do not have sufficient security permission to install this addin". I have tried the right click, run as administrator solution but do not see that as an option. Have tried from a desktop shortcut, All...

All, Thanks in advance for any assistance you may be able to give. My scenario is this - A user will select charges they want to process based on 3 combo boxes. The results will be displayed in a subform. The user will then select from the subform a particular record they want to use against...

Hi, I have a database that is used to determine shipping rates based on multiple factors. I am trying to determine what the weight break would be when given a shipment weight. Below is the table layout and an example of what I am looking to get. Table MinWgt MaxWgt Zone Rate Minimum...

Hi, Thanks in advance for any help. What I am trying to do is calculate what the rate should be on a shipment. I have the rate and min weight and max weight. I get via an input the weight of the shipment. I need to determine what that shipment rate we should be charged. Table examples...

Hi, I am trying to have 2 combo boxes requery after data is selected (ex: cboContractFeeCode is 1st combobox, cboOP is the 2nd, and cboDP is the 3rd). When an item is selected in the 3rd box, it is dispositioned, so it does not appear again in the 3rd box. After selecting item in 1st box...

Hi, I am trying to have code that allow the user to transfer a spreadsheet and not have to fill in the path and file name each time. The file name changes on a daily basis (Data 07-08-10.xlsx yesterday Data 07-09-10.xlsx today). I have built the form to read from a table the path name and...

Hi, I am attempting to have tables reattach to another table when a user logs in as well as having ability to see a help file. I cannot define the path since not all users are able to create directories except under their respective login name (C:\Documents and Settings\JohnDoe\My Documents\)...

Hi, I have looked at multiple examples of doing a running sum over a list of detail records. None of the examples provides the solution I am looking for. What I want to have is a report that looks like this. No. Aisle Bin Box ID Qty...

All, First, I thought I submitted this yesterday, but do not see it in the forum or under my threads, so apologize if it is redundant. What I am looking for is a way to include the import/export specifications when I distribute an app. The app will be on users machines in sites around the...

I am having problems with the SendKey function in Vista Home Premium. It works fine in XP or XP Pro. This code generates an error that "The SendKeys action requires "program name" Utility Add-In to be loaded." No idea what they are talking about. Function Macro2() On Error GoTo Macro2_Err...

Hi, 1st thanks very much for your time. My question is how do I automatically link to a network drive at XP startup? My scenario is this - on my hardwired machine, not a problem to do, but on the wireless machines, does not automatically link, must double-click the link via Windows Explorer...

I have written several easy reports that indicate results of surveys. There are only 4 fields of results. The requestor would like to indicate on each which was the highest score, but always have the answer showing in the proper field (see below for example). Does anyone have any idea on how...