Search results for query: *

I found a "work around". Luckily the field will contain a number, so I took the text string and added 0 to it. I did this before the sql statement that imports it into the database. This forced the value to 0 when it was originally null. Anyway, thanks Malcolm. I am going to post...

Can anyone give me an example of the script to use with the NVL function? I am having trouble reading in data from a csv file when a row of the data contains a null value. It is skipping the entire row. If I can force the nulls to 0, I think it would import the data into my table... I am...

I am importing data into Access from a csv file. The problem is, one of the fields in a certain column is sometimes blank (null). When reading the data into the access table, the rows where the values are null do not come into the table. How can I fix this problem? Thanks! Here is the code...

I have a similar situation as well. I am trying to get data from a main form to another form I open when "not in list" is activated. You can get data from a different form that is open by setting the default value of the form like this in the property settings. =[Forms]![Main...

Thanks Miah. I had to download nmake.exe and nmake.err from microsoft's ftp server. It came in the form of nmake15.exe. After I did that, the nmake works the same as the make. I put the nmake.exe and nmake.err in my path and then downloaded the modules I wanted. I put the module in a...

I am not sure I understand where your problem is. If when you view your table, some of the columns are missing which prevents you from seeing some of your data, maybe you need to open your table and choose FORMAT from the menu bar and choose unhide columns. Maybe some of your data is in hidden...

I don't understand how to do that. I am just a beginner. I have continued to research this and I think one of my problems is that I don't have the Text::CSV module installed. I found it on CSPAN, but can't figure out how to properly install it. I am running a Win32 system. I would like to...

I am a beginner at Perl, but am working on a team to import a csv file into an Access Database as a table. My part is really to write the SQL code which I am familiar with, but our team can't get the data from the csv file so I can manipulate it with SQL. We researched how to bring the csv...