Recent content by Tekture

Wow, I certaintly learned a lot with that post namliam. After messing around with it, your first set of formulas assume that there will only be 1 space located in the description line (Device 1) but this is not always the case. For ex, this is one description line: "Gloves, leather, Size 6"...

Vlookup won't work?

Well, this report is ran once a month. My side of the work load is only a 3,000 item section. The entire inventory is some 20,000 items long. If i could automate it, I can pass it along to others. Currently, we just look at everything the way it comes out on a txt report. The months...

Well, that's how I did it, but had to go back through and do a lot of things by hand. It's not obvious in the example, but there are places that are blank and that will throw that column off. The item number sometimes has a D, sometimes not. With 3,000 lines, this took me half a day to get...

Example is attached.

Ahh, yes, i'm sorry. The total number of rows in one section is 7 and yes every section is the same length throughout the report. The unique item numbers are not all the same length though. Some are 4 numbers and others are 5.

The sort function (as far as i can tell) will only sort 1 row at a time based on contents of column selected. So say you have 3 rows of data that should be treated as if they were one. How would you be able to sort 3 rows at a time? In my situation, for example, D1=1 and D7=2 but all the cells...

I was able to do all 3000 lines today by hand (and a few shortcuts) but i would still like to know if this concept is possible. After thinking about it some more, maybe this is a better way to explain: Every other row is off by half, so row 1, 3, 5, 7, etc... are all lined up, and the rest...

I'm using an old AS400 mainframe system here. I can export a report that i want into a txt file and then import to excel but i'm running into problems when i try to separate all this data. Unfortunatly when the report exports to txt file, it does not keep the column widths as seen in the...

I want to turn off the access shell and only display what I have created. I want it to float on the desktop as if it's a standalone program. I searched the forums and I found several useful posts concerning this topic but i just wanted to investigate further. I thought I had done this once...

It works perfect! Thanks RG

I went in and added my location as a trusted source and Access no longer prompts me with a security warning when it opens. BUT, I'm still have the problem, which means it's most likely something wrong with the code. Sigh... Thanks SOS and Ross I also requeried the DB and nothing. I did...

Private Sub EmpID_Click() Dim SQL As String SQL = "SELECT * FROM Employee WHERE (((Employee.EmployeeID)=" & Me.EmpID & "));" Me.Parent.sfEmp.Form.RecordSource = SQL Me.Parent.tabPublisher = 1 End Sub This was the code we had before Office 2007. The purpose of this code is to...

Ahh, let me clarify, the forms are working fine. The only problem i'm having is when i click the link on the main form and the popup appears, it has ALL records for ALL employees. I only want it to show me those recrods for the current employee the main form is on. The main form is also being...

Form 1 has all the regular information for employees. Form 2 has the dates of their "progress reports" for each year (you'll have multiple records for a single employee on Form 1) Form 2 is also a popup (just a small window with a few date fields and a record selector so you can scroll through...