Search results for query: *

Hi, I've got a column of cells with date/time values and I need to compare to an specific date and time in VBA. I'm using a CASE where cell.value appears to be stored as decimal. How do I format specific the date and time that I created to see if the cell date/time is before or after? Cell D2...

Hi, I've been searching through various forums on the web and then attempted to search for a solution on Tek-tips, no luck. I've also seen that many are getting the same error that I was getting. Using VBA within Excel, I want to open a zip archive and save to a selected folder. Here is my...

Good Morning, I want to query a table that contains multiple appointments with time stamped status code changes for each appointment. Specifically, I need to pull the immediate next record in time, after the last "IN" status. Below, you see that in this case, "MT" is the next code after the...

Hi, I'm trying to create this query in Informix that will return the first row from each of these "Appt"'s. I originally wanted to find the minimum date but unfortunately, there are multiple PO's and Appt's that have the same date. I know that this should probably be simple but I can't seem to...

Hi everyone, I have a list of items that I would like spaced as evenly as possibly in a set number of rows. Eg. 7 items need to be spread over 51 rows (much larger in real circumstance). I hope that there is procedure that can work for several different circumstances. 1. Apple 2. 3. Banana...

Hi, I have to move pick locations around in a facility to reduce congestion by spreading high volume locations out. I hope that someone can help me create some vba that will provide a sort column; this sort column would evenly spread values through a list. See the attached for the desired...

Hi, I've tried searching through the forum but can't find a solution for the issue that I'm having. In Excel VBA (2007), I've created a routine to dymamically build a range and save into a string. Once the entire range is collected, I've attempted to create a named range but get a runtime...

Hi, I have created a unique number for my MS Access 2007 table. This number takes 3 of the existing fields and concatenates them together. The DB has a temporary import table which will only add records to the main table if the unique number doesn't exist in the master table. What I would...

Hi Guys, I have an Access form that has a query of records that need to be edited...sometimes referencing another screen on a different application. The issue that my users are experiencing is that when they "ALT+TAB" to another application, the sheet goes back to the top of the access form when...

Hi there, I have a database with an "error" table. Two fields lookup muliple values to their corresponding linked tables. Combo Box1-> tblError1 = ID; Type Combo Box2-> tblError2 = ID; Type; Description Essentially, I've managed to get the query working on Combo Box2 "afterupdate" on Combo...

Hi there, MS Access (2003/2007) Windows XP I've looked through the forums but can't find an exact example of this problem. I have a text file kickout from a European designed system which displays date in the format "DD/MM/YY". In order to compliment most of the systems (setup as "MM/DD/YY"), I...

Hi Guys, I know that the capture feature captures scrolling screen prints and that the history can capture screen changes but I am in a screen that queries inventory locations; when I hit a key (F8), it displays the next 10 results for that range. Other than copying and pasting into a text...

Hi guys, I would like to find out how to create a right click selection pointing to a batch file, while running within the folder that has been selected (much like nature of the "Open Command Window here" option but with a .bat file executed following). Thanks, Aurillius

Hi, I want to create a side banner on each page of a (dynamic)running Excel sheet. The sheet could be anywhere from 1 to 20 pages printout. How can I do this with vba coding or is there a way??

Hi everyone, I have a query which left joins to 3 subqueries containing filters. The syntax looks fine but I keep getting an missing operator on the last expression. [MAIN PARTS].BULKROOT = 2004SALES.BULKROOT; Here is the statement: SELECT * FROM (([MAIN PARTS] LEFT JOIN (SELECT [MAIN...

Hi, I'm trying to create a left join between 2 tables and the right table has a filter. The problem that I'm having is that I'd like to still show all records on the left table and show a blank cell on the right table. Here is a simplified version of what I have... SELECT tableA.item FROM...

Hi guys, I want to cancel the installation of XP on my laptop. We have corporate serials at my office but should have done a fresh installation (wrong disk) and the serial (new system) won't work. How do I cancel this when I have no floppy drive?

Hi, I have a form that is generated from a search from the original form. The new form displays a query from which I want to double click one line and have it select the exact item from the related combo box and text box on the original form. This is the code that I started and it's executed...

Hi there, This was a thread that I started last year but no one replied to it. Is there someone that can solve this? .... I just received a huge kickout table from our data company. There is over 10 thousand records. In order to compare this to our records, I have to group the parts by...

Hi, I have a series of files that need to be renamed so that the low numbers are the highest and the high numbers are the lowest. Change to something like: K8966-001.jpg to K8966-030 K8966-002.jpg to K8966-029 K8966-003.jpg to K8966-028 K8966-004.jpg to K8966-027 K8966-005.jpg to K8966-026...