Search results for query: *

This line if (strcell.indexOf("Team")>=0); didn't work, tried: i2 = strcell.indexOf("Team")>=0; if (i2==true); Same log Thank you for your help.

New to JS. Working with it in google sheets. For some reason, i can't get the nested if to filter out at the bottom. code is not finished. the log is at the very bottom. it should only log 4 times. Please tell me that JS in Google sheets is not that flaky. function loopsearch(){...

update: I currently am running latest access on my laptop. opened up the database with no special conversion (database was created and maintained in Access 2003, and as i put in previous threads, it works. I setup another laptop with 2003 on it exclusively and brought the database over from...

Basically, File not Found, and that was it.

neither Open "C:\CSVUpload\od.csv" For Input As #1 ignore the comment talking about assuming test.csv is in c: drive. That's a copy paste thing from somewhere.

ok, so this is the exact code that worked on my laptop. Her computer i changed the file location to a C: drive folder as Andrzejek suggested and i still couldn't get it to work. Filename was CSVUpload and file name was od.csv.

Ok, kept getting a 'Couldn't find file' I checked and checked. Even copy pasted the filename. The code i posted worked on my laptop. On install i changed the directory and the filename. Was thinking since it was Access 2003 there was some missing dll or library inclusion that would help...

Private Sub Command107_Click() On Error GoTo Err_Command107_Click Dim strTextLine As String Dim aryMyData() As String Dim strSQL As String Dim directory As String Dim FileName As String Dim i As Integer Dim i2 As Integer Dim currtoint As String Dim i3 As Integer directory =...

Ok, i got this to work on my laptop. When i transferred to the host computer i could even get the open directory to find the file. Help. I have the latest and greatest Access on my laptop but its Access 2003. Is there a functionality that i need...a library or something.

Ok, got it. Just took out the '$' using right function. Thanks again for your help.

the destination table column is designated number. I know of the difference in data types. Is there a quick way around it. like something that knocks off the first digit of a variable, or some magic conversion tool?

Runtime error '3075' Syntax error (missing operator) in query expression 'Collected Amount' Put some logic in to skip the first line read before it hits docmd and it worked until... Syntax error is query expression '$1.00' So im putting a currency into a number data type. Are there any quick...

Andr, Also, what is the # sign for? I have never seen that in SQL queries. Also, i agree, there should be a sarcasm font

Andr, Ok, so i don't have a column of numbers in the csv file. Are you asking that i add them to the file then run this or are those numbers based on the comma delimiting?

Andr, Why bracket some of the column names?

Andr, Im doing this for our soup kitchen. The database was designed by someone else so im stuck with table design for now because of the heavy integration nature of the present database. The csv file format is basically canned long format export from a donations website. Just looking to give...

Example csv: attached I've changed the approach a bit. here is what i have been working on today. Dim filepath As String Dim sqlinsert As String Dim sqlvalue As String Dim sqlquery As String Dim sqlwhere As String 'Set db = CurrentDb directory = "C:\Users\gmartin\Desktop\Equip\The Soup...

So i basically need to search through each column header looking for 1 of 5 strings. Once there is a match i grab all data under that header.

I have a .csv file that has information i want to import. I tried importing the present csv into a table and moving data via Insert Into Select statement but couldn't get it to work. The easiest route it seems is to take the csv file and format it to match the table i want to move it to. Then...