Recent content by jesseb

When importing a CSV file, sometimes a few characters that Access must not recognize are in the file. On import, Access simply stops importing the rest of the rows and acts as if it had imported everything. Has anyone come across this and created a solution to it? The character I have found...

It works. I think it is saying those numbers 1 or 8.

What is this saying? Anything like 18*?

Careful with the Int() function. It looks like it is rounding but it is truncating instead. So 7.9 becomes 7...

I have done it finally, here is the code in case anyone wants to see how it ended up: In this case I used 2 tables oracle and output. Sub FillTbl() Dim DB As Database Dim Oracle As Recordset Dim Output As Recordset Dim StartDte As Date Dim i As Integer, Period As Integer Dim units As Double...

raskew- Is there anyway to do the fifth week only if the column -NumWeeks- in the table -Operations- is 5, otherwise do 4?

These could definately work. I just have to modify them a bit. The months don't always start on the the first and some go 4 weeks others go 5 but I have all those numbers in a table. I think I can get it from this. Thanks a lot.

That is what I am going to have to do and would work. But I am going to need to do this every month and the number of weeks to change is always changing. So I would have to put a lot of effort to do it that way every time I needed to do this conversion. This situation could be handled by some...

That is almost what I am looking for. I think I will have to use the dateadd() but the thing is, I need to display the weeks in between the start week and the end week. I am looking to do it in Excel and use some VBA. But if there is a better way to do it in Access that would be cool. [This...

I am trying to figure out a way to take a month and convert it to a certain amount of weeks. For example, a month starts on 12/31/03. I want to to add 5 weeks and show each week added in a column. So it would look like 12/31/03; 1/7/03; 1/14/03... Does anyone know how to get this accomplished?

Yeah, that is what I originally thought too. But it doesn't seem to be.

I use the Microsoft Excel 10.0 object references in a database. The problem is that when someone else opens the database and runs the code if they have Excel 2000 I need to go in and add the Microsoft Excel 9.0 object library. How do I solve this issue?

I would like to create a report based of a crosstab query- the report takes in all fields on the query. But the fields will change. So it seems to me that I need to write the SQL to make the report grab all the fields and do what it does. But I do not know where to start. So if someone can...

I get an error on a form that is perplexing ot me. When the form is first opened and a person inputs and then clicks a "save" button I have placed the error # 29068 occurs. The code behind the button is: DoCmd.save acForm, Me.name DoCmd.GoToRecord , , acNewRec It asks to end or debug. If...

I am a little lost with what you are saying. But I also have a DB that imports Excel spreadsheets and have came up with a way to stop that. I run a query that checks if a record is already in the database. I check that query to see if it is empty and then if it is empty, I allow the import...