Search results

I posted on Friday a very similar issue with a recordset. I've used most of the recordset portion of that sample code, so I don't think there's a problem with that. I think there is some problem with how the SQL statement interacts with the recordset, but I don't know recordsets well enough to...

That was it! Thank you. I figured it had something to do with a record set. Whenever I get to these types of things I get out of my league. Thank you

I have a variable I need to populate with a value and in turn populate a field on a form with that variable value. The value I want to set the variable to is the result of this query: SELECT TOP 1 WarehouseLocation.LocationCode FROM WarehouseLocation WHERE (WarehouseLocation.CurrentUnits <...

You did it! Thanks.

I have a field that I need to perform and update statement to. I need to replace any instance of quotation marks (") with double quotation marks (""). For this I know I need the replace function, but I'm not clear on the quotation mark portion of the syntax. Here's what I have...

Can't believe I didn't know about LEFT function...duh. I think I actually solved it by just doing: Field: LEFT(Table.Field, 30) Thanks for posting.

I would like to limit the results I get in a particular field of my query to 30 characters. The field length currently has a length limit of 50 characters, but I need to import the results of this query into a different database and the corresponding field in the destination database only has...

Oops. Nevermind. I forgot the ":". Thanks for the help. I hope you are making a lot of money out there. You are an absolute vba genius. Thanks as always.

Do I have to DIM GetAnother as something? I'm getting a Compile error: Sub or Function not defined. Here is what I put in: Dim dlgOpen As FileDialog GetAnother Set dlgOpen = Application.FileDialog(msoFileDialogOpen) dlgOpen.InitialFileName = "Y:\Access Databases\Import Files to CRM...

I have a situation where I'd like to import multiple files into an access database. Most of the VBA I'm okay with, I'm just new to using loops, so I'm hoping someone has a good ability to help me with looping this function. I'd like to start out by opening a dialog box that allows the user...

I think that was it, thanks spikepl

No luck. I added the Microsoft ActiveX Data Objects 2.8 Library. Any other ideas? There are many other library versions of ActiveX Data Objects (2.0, 2.1, 2.5, 2.6, 2.7). I also tried adding Microsoft ActiveX Data Objects Recordset 2.8 Library. Also no luck there. I'm still getting the...

I transferred the contents of my .mdb 2003 version of access to the newer standard of .accdb. Most everything is working except a few pieces of code. I think it has something to do with object reference libraries but I'm getting an error when I try to add which ones I think will fix the...

Worked perfectly. Thank you! I knew there must've just been some syntax issue. Thanks again!

I am having a difficult time with some VBA code running a replace function. Specifically, I'm trying to update a field that contains gender information. The information is contained in my database as follows: "Womens". HOWEVER, I need to run a VBA function to replace all instances of "Womens"...

I have a set query that displays items that are in a certain status. Its more like a SQL server view if you're familiar with that. My back end is a SQL server 2005, and Access is my front end. Here's my problem. So, the items that display in this query are those that meet certain criteria...

Strange enough, it looks like this was a Microsoft DAO object library reference problem. I unchecked the object library reference and now the problems have gone away......Not sure I understand why.

I have not upgraded to the ACCDB format. I am using Access as a front end. Do I need to do this? I'm not exactly sure how to do that. Until now I haven't had this problem. I did set the file locations that I'm running the MDB from to be a trusted location. Still no effect there.

I have a bunch of code that was written in 2003. I have since "upgraded" office computers to Access 2007. Now I am having issues running the same code that has worked without problems for ages. An example: Date() doesn't work in VBA code or update queries. I'm given the message "Run-time...

Autokeys macros were the answer. Thanks. Yeah, I'm not sure where to look in investigating the lockup problem with the switchboard. Since it seems to be isolated to that, I wasn't that worried.