Microsoft Access / VBA Forum

I have a save button on my form that, on click, saves the new record, but I would like to have a message box appear and ask if the user is sure they want to save (yes/ok or no/cancel). Then once the user has chosen yes/ok to save the new record, the form should close. Any suggestions are appreciated! Dan B.

Hi Could someone please post a split function to split a string into an array based on a separator such as comma? Thanks Regards

I am a complete idiot when it comes to access. Now that said, I work for a computer security company and one of our customers came to us with an access problem. They had been running fine for a long time. Then about a month ago there main server that hosted all the .mdb files crashed. So they restored everything to a new server (I believe...

I need help in finding out why I am not getting any data in my query. When I select all the fields in one table in my query grid and run it, the data is there. However, when I try to do it using to related tables and pull fields from both table in my query rid and run the query, data from both related tables are not showing in my query...

I have a form in which I collect info from the user and then process various tables. Now, I need to call a report and pass two parameters to it so it’ll only select the desired records for reporting. I’m familiar with the application of OpenArgs and used it successfully to pass several parameters to other forms (using a delimiter to separate and...

I am trying to move a subform onto the next record with: DoCmd.GoToRecord acForm, "MaintainAssets_edit", acNext but when I do this I get "The object 'MaintainAssets_edit' is isn't open". I know I could easily put the controls in the subform itself but I want the record controls at the top of the page, outside of the subform. Thanks for...

I should be able to figure this one out, but it's late: I'm trying to sort a report by two fields. I can do it easily if I hard-code the fields. However, I want to get user input and store the input in variables, which would then be used in the OrderBy method. Right now it looks like this and is not working: rptMember.OrderBy = strfield1,...

I have a form where I have turned off the default navigation buttons. I then created my own. This works fine. The only questions that I have is on the default navigation buttons it shows total records. How can I show this? I have a text box that shows the current record using: Text1 = Me.Current I want to show the total number of records....

I am trying to use Windows Task Scheduler to run a batch file for an already open MS Access database. Below is the syntax to the batch file: Batch file: DailySalesExport.bat REM This runs the macro that exports the reports to the J drive PATH = "C:\Program Files\Microsoft Office\Office\;C:\Windows\Command" START /WAIT Msaccess.exe...

How can I convert my query in MS Access to change date to varchar? (SELECT LEFT(,10) AS , CAST(LEFT(RIGHT(,12),2) AS VARCHAR) AS , COUNT(FORMAT(LEFT(RIGHT(,12),2) AS INT)) AS , RIGHT(,10) AS FROM This is just a part of my long query.

I need to display the record number on a form - replacing the Access Navigation Buttons. I found a routine on Access Web that is supposed to work but when I use it I am told that "Object doesn't support this property or method" The code it uses is placed on the on Current Event and is as follows: With Me.RecordsetClone .Bookmark =...

Hi All. I was wondering if there was a way to set the primary key of a table with VBA? I have a make table query that runs, however when it creates the table it does not set a primary key. I would like to do this with VBA instead of manually. Any help would be great. Thanks.

Hello Everybody, There is SQL Server 2008 R2 database with MS Access front-end (linked ODBC tables). I can see all linked tables in MS Access and can add new rows. However, when trying to update or delete existing data, I got error: Process is stopped by Microsoft Jet because multiple users are trying to edit the same data simultaneously....

Is there a difference between the Form_Open and Form_Load events? When should I use one rather than the other? I have several forms that require code to run when they open... or is it when they load? Thanks in advance.

I used the Report Wizard to create a report that is generally working pretty well. However, it set up the structure as follows: Report Page Header Group 1 Header - Header for the group Group 2 Header - This has my column headings for the details. Details

I am trying to populate a listbox from another listbox on a access form. My first listbox has names of tables on a linked odbc databse. I am trying to display the tuples of the table in the second listbox based on the selection of table name in the first listbox I am new to VBA, and am trying to do that in the following manner: Private Sub...

I have the following piece of code for my query. For some reason some of the records showup with the FileCount field having an error. When I click in the field it says "Data type mismatch in criteria expression." I assume that it is talking about the criteria in the DCount() function. The three fields that are referenced in the criteria...

I have an existing table which describes Streets and sections of streets between intersections: Table 1: Streets by Intersections Street Area Ann St. Main to Jackson Ann. St. Jackson To Summer Ann St. Summer to End Joe St. Aberdeen to Mike and so on for 1200 records

Hello--I've got a query that uses DatePart("m",) to select records for a particular month, and then a report based on that query. I'd like to be able to create a field in the report that says what month they are for. I can get the month number by using =DatePart("m",) in a text box, but I can't find a way to convert it to the month name. I've...

Hi All, I want to Count the number of members in my database that have specific criteria, such as Blue eyes, or Brown hair. I have fields named Hair and Eyes, and others ofcourse, but I just want my VBA code to count the number with the specified value, ie Blue Eyes, and assign it to a variable that I can use, that is already defined. ...

I am programming an Access database for a blind co-worker. I need to plug in a DLL, but I've never done it before. Here's all the information that is available (after hours of Googling): http://blindprogramming.com/pipermail/programming_blindprogramming.com/2006-February/005286.html The purpose of this DLL is to pass a string to the DLL...

Hello, I have developed and tested an Access database that I now wish to distribute. It works well on all computers tested, including an Apple Mac running Parallels Desktop, but with one exception. When using the Mac, on the command to open an existing PDF it fails to deliver, with no error message. The VBA I am using to do this is as follows:...

This week’s Tip of the Week will clearly demonstrate how you can dynamically set the Drop Down List Width of a Combo Box to the length of the longest item in its Row Source. The inspiration for this Tip came from one of our own resident Experts, mshmyob. In response to a Thread relating to this very Topic, mshmyob came up with a rather ingenious...

I read multiple messages about this but i still can t get it working i m trying to update my access db using an update query and set a null (basically empty cell) date value I tried Date = Null but it just won t accept it. I tried different version with '' ## ""

Thanks for taking time to read my questions. I'm looking for a way in Access that I could run a query that would return table schema information. Specifically I need to get the column name, data type and size of the column. In SQL there is a stored procedure that does this 'SP_Help <table Name>. This command gives me more than I need...