Search results

Can anyone help me with setting up a Visual Basic project to where the datasource I use is a Access database on my harddrive. This Access database isn't linked to a server or anything. It's just a database I created and would like for my project to open this file everytime it's attempting to...

I'm trying to figure out how to make it to where I connect to a database I've created on the harddrive. I don't wanna code through Access and prefer Visual Studio. The database is just something I've created on my harddrive. It's connected to a server using an ODBC connection. It's just an...

Hello, what I'm trying to do is write data from a report (manifest report) that was generated. The report is ever changing, so I use the unique manifest number generated that's part of the report to determine what data I need to write to the CSV file. Also, in this CSV file, I am trying to use...

found that problem Ok, I found the problem with that. After the subform name, I needed to type .Form as well. Example: Me.qryK95subform.Form.RecordSource = strSQL Now, my problem is a 3078 error which states that the input table or query does not exist. It says for me to make sure I didn't...

control wizard The control wizard isn't doing everything I want it to. Supposedly, it's able to create both the main form and subform at the same time. I've followed step-by-step instructions from a couple of places and can't get the menu to popup that will allow me to create both forms at...

can send file with help I can send a file of what I'm doing currently, but will need help on how to attach the file. I can cut my database down to under 100 KB. However, when I zip the file, the filesize goes up to 5 MB (which is too big to upload). Does anyone have any suggestions as to how...

Hello, I'm trying to use information based on items selected in a combobox in the main form. Once the user selects the desired info in the comboboxes on the main form, I want the subform to display the data that matches the search criteria in the main form. For instance, if I select a job...

Hello, I'm trying to use information based on items selected in a combobox in the main form. Once the user selects the desired info in the comboboxes on the main form, I want the subform to display the data that matches the search criteria in the main form. For instance, if I select a job...

I have a problem where a flexgrid isn't populating the data. However, when I put a breakpoint in the program and step through it, the flexgrid then gets populated with the correct data. I've used breakpoints in different places, and I can't seem to find any problems in the steps when running...

I'm trying to add a Flex Grid in my access Database. I'm using Visual Basic 6.0, but can't seem to find the Hierarchial FlexGrid Control or the Microsoft ADO Data Control (OLEDB). It's supposed to be under the Project menu, but I can't find it. I'm trying to add in a new library, but don't...

.Update I tried your suggestion and added the .Update at the end of the .Addnew fields. It didn't work with the way I put in the .Update. I might've added it in incorrectly ( I don't know). Do you think it might have have something to do with the way I set my lvINTERNAL_ID? It might be...

I'm having a problem with my form where everytime I try importing a file into my database, I received an "overflow" message. It appears the problem is somewhere in my Do loop. The following shows what my code looks like right now: Open txtCSVFileToUse For Input As #1 lvRandNum = Int((1000000...

The problem The problem is I don't think any of these examples (which are only a handful that apply to importing) have the necessary code I can use to decipher what I need to use in my import sub command. I feel I'm getting pretty close, but like when it comes to field names, how do I import...

difference between SpecName and FileName? So if you don't use the import wizard, where does the spec name come into play? Where else should the spec name be applied in the form? Also, where would the filename come from? Is it the file you just browsed for and grabbed? If so, how would that...

Can't seem to find an import example to fit mine With the 3 or 4 different examples of imports I found, I can't seem to find one that's close enough to mine to where the modifications aren't difficult. When importing, what types of code need to be in the sub?

Me.tbHidden.SetFocus? What does this line do? Me.tbHidden.SetFocus It's where I'm receiving an error in the programming. I used what you had in a previous thread for importing a file, and edited it to fit my own. Just wondering what this line means?

Couldn't find a form that imported I couldn't find anything from those samples that imported using a form. Do you know where I could find some sample code that illustrates how to import a file that's been pulled into a text box? I just need to know how a simple sample code thing to Import a...

Here's where I'm at.... Thanks for your help! I found out how to locate a .csv file through the local directory. I also am able to show the file's location in a text box. Others examples are helpful, but still have some differences that are hard for me to edit into my current form. What I...

Hello, I was needing some help coming up with the code to search the local hard drive and grab a file and then import it into an Access table. I'm trying to do this on a form if possible. If you know of another way, that would work. Any help would be appreciated. Thanks.