Search results

ok. thank you. now is there a way I can create a vb script in notepad?

I have a vba program that runs from an autoexec macro then quits the application. Some of the users don't have MS Access though. Is there a way users can run this program without having MS Access installed on their machines?

Can someone please tell me why this is happening? I have 2 combo boxes. [cboSearchField] and [cboSearchValue]. The values in [cboSearchField] are (ReqID, subject, requestor). These are fields in my table. After update of [cboSearchField], [cboSearchValue] returns the values for the field...

thank you MStef. I don't know what the problem was but when the guy who was logged in shut down his computer all the way then the the .lbd file was removed. I don't know what would cause this. Do you have any guesses?

I trying to modify the design of some forms in my database but the locking file (.ldb) is showing that some users are still logged in. I had everybody to log out and confirmed that they have logged out but the .ldb is still showing those uses as being logged in. What do I do in that situation?

I'm trying to filter my report while my report remains open. I have a form that opens when the report opens. The form has three combo boxes that are used to filter the form. On each combo box AfterUpdate event I have the following code: Dim rpt As Report Set rpt = Report_rptIssuesReport...

Thanks guy!!! That's awesome. That's just what I was looking for. Thank you so much.

Anyone else have any ideas? Can you use an "IIF" statement on the crtieria line --- something like? IIf(Not IsNull([Forms]![FrmFilterReport]![cboVendor]),Not Is Null,[Forms]![FrmFilterReport]![cboVendor]) How would I write my criteria if I want to return all records if there's no selection...

But I have three combo boxes that will provide the criteria for the query. For example: cboVendor, cboStatus, cboBuilding. The criteria for the query is to return all records wher the vendor is equal to cboVendor and the status is equal to cboStatus and the building is equal to cboBuilding...

I am trying to add criteria to my query using what the user selects from a form. That's easy. Basically, on the criteria line in the query grid I have the following criteria under the [Vendor] field, [Forms]![FrmFilterReport]![cboVendor]. That returns all records where the vendor is equal to...

I'm sorry. It will be a max of 6 characters, but I may inventory over 999,999 keys. I want a random number of 6 characters. Can I only get 999,999 different combinations with 6 characters?

Thank you but none of that helped. I don't need to anything with dates. I just simply want a number or number combined with letters that will be unique for each record I add. The unique identifier can't be more than 6 characters because the key isn't that big for more than 6 characters to be...

Is there a way to format the random auto number to just be 4 digits long? Or does anyone know how I can programatically create an auto unique field? This number has to be stamped on a key so it can't be longer than 4 characters but it has to be unique. Any help would be greatly appreciated.

thanks for the quick response, but I've tried deleting the ldb I can't because it says someone is in the db. But I've had everyone log out and shut there computers down. I don't know what is going on.

My database is displaying a message that someone is in the database. But there's no one in the database. I had every user that the locking file displayed to log out of the database and shut down there computers. The database is still showing that it's locked. How do I solve that issue?

thank you gemma-the-husky, That put me in the right direction. Here's the code I used: Do Until rst.EOF strMasterCut = rst!MasterCut rst.MoveNext Do While IsNull(rst!MasterCut) rst.Edit rst!MasterCut = strMasterCut rst.Update...

Here's my problem ... I need to get the key stamp populated for the records that don't have a key stamp. For example if you look at the database I attached and in the table you'll see [keystamp], [field20]. [field20] repeats Driver, Master, Bottom and they should have the same key stamp. But...

thank you neileg.

I apologize for the extra posts. My computer was acting up.

I have a value that I need to enter into my table. The value is : 12(4B)(5)(c) but when I enter that value the "(c)" converts to the copyright symbol ©. How do I enter that value without it converting to a symbol.