Search results

Thanks Paul and Dave - I have what I need now and have been able to get this to work. but the newly created table is not showing up in the objects window of access. I first tested it by doing the install on the front end where I was working and to see the table I had to close the database and...

That's very helpful - thanks. I hope to add a browse box for the user to find the backend - that should be possible correct? and what about linking it to another front end - keep in mind that this will be run from a one time use only front end because just putting it in the back end doesn't...

Can I create a table in the back end of my database using VBA in the front end? My client is using this system and I can't easily go to their location. I need to create a table on the back end and have it available in the front end applications. My thought is to create a front end only for...

Thanks - but I do not know the name of the field - it may change with whatever the user imports.

OK so maybe I am asking the incorrectly - I just need to check to see if the records in the first column are null, or blank - no matter what the name of the field is. I would expect that there is a way to do this, but maybe not.

Gina - Either way would work for me - but what I am trying to do with the code in my original post is your second choice - but the code does not work. I get the error code 2417, "The expression you entered as a query parameter produced this error 'column1'" So I am asking what is the proper way...

Gina - yes I am checking the table in Access spike - What? I don't understand your comment? CJ - No - what I have already is correct for my usage, thanks. I just want to check for an empty table (which is not actually empty because the fields must have something in them to show the record...

I am giving the user the ability to import a table from excel and trying to cover all of the possibilities of import error with custom message boxes. I have most covered but have a tricky one. If the user imports a table that has records that are null I need to detect this (ie. if the user...

Thank you CJ - exactly what I needed!

I have created code to import and excel file and create a table from that info. Now I need to confirm that the import has the correct Datatype of Number and Fieldsize of Double for one of the columns. Any thoughts on how to do this in vba? Thanks Sue

Figured it out - had to pass a value for NoBrand to the sub and then do an If statement there. - as I see you posted pbaldy - thanks

What I have is working almost. It is as follows: Public Function NoBrand() If DCount("Brand", "UserBrandsTBL", "Include = " & True & "") = 0 Then MsgBox "You must select a brand before proceeding.", vbExclamation, "Select Brand" Me.UserBrandsFRM.SetFocus Exit Function End If...

I have a code that needs to be run on click of every button on my switchboard. It checks to be sure that the user has made a selection in a subform on the switchboard that the entire database then works on. If there is no selection there are all kinds of errors. I have created the code as...

Thanks for your trying to help me but I just don't understand what the process is here. I need to save the images within the database - in a table. I need to assign one of the headers to a report based on a selection made of the brand. The table with the images, has a field "brand" and the...

Thanks - but this is a report not a form (though I believe your comment - and that of llk - also applies to forms.) Again my problem is not as much where to put the code but what code to use. Please help if you can.

I will try that tomorrow morning, thanks. I was hoping someone could give me some insight on how to actually code this. I am thinking of using a DLoopUp basically as stated below: OleObject = DLookup ("Image", "HeaderTBL", "Brand= 'SelectedBrand'") where SelectedBrand will refer to the...

I have a database used for several product lines. Depending on the product line selected, I need to add an image to my report as the header for it. I need to store the images (there are only 3) in the database and cannot have an external link to them. Have been trying to figure out the best...

CJ - Thanks - that cut the code from 2 lines to one! works perfectly Sue

Figured it would have to be coded, but did not want to write the code if there was a simpler way. Thanks for your direction. Think I can make that work. Sue

My table has a yes/no field and about 10 records. I have created a form for the user to select which of the records he wishes to use - the records are displayed in a continuous form with a check box for the yes/no field. The user is to select one record by checking the check box in the record...