Microsoft Access / VBA Forum

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 =...

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 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...

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 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 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 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 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...

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 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, Can't seem to find a work around for what I thought would be something easy to do. I have a table that contains 3 columns of date values. The date values most often, but not 100%, include the time. I would like to truncate these values so that they are date only. By that, I meant that I do not wish to format or otherwise hide the time, I...

I built a select query filled with fields from multiple tables and queries. I have one field in this particluar query that will filter out a single order number. In the criteria box I put and that does the trick for filtering for one single record. What would the criteria syntax be if I wanted to filter for multiple order numbers? I'm thinking I...

We have a query that calculates the percentage of customers we have in three groups. (Active, Inactive, Pending). The table we get the precentages from has over 1 million records. I need to design a query that will pull 100 records from a table using the percentages of each group. Ex. if the Active Group is 53% of the database then 53 of my...

Hey Forum! In my project there is a table containing archival data. This table currently has more than 3 million records covering a period of 11 years. Each month our team scans equipment for inventory. Unfortunately, many times during the month the same piece of equipment is inventoried multiple times. What I am looking to do is to delete...

Hi folks. I have a query opened from a menu bar. Is it possible to make the query read only? Thanks Al

Can anyone explain this error. I have the following code in a button on a form Private Sub cmdExit_Click() DoCmd.Close acForm, "ActivityMaintenance" End Sub

I'm sure I knew how to do this once, but now I can't find the place to set it. A report has a group header for Organisation and then a detail section for each Contact in that organisation. The report shows up just fine, except I don't want it to break a page in the midst of the detail records, or before they start. That is, I don't want ......

So, I had this bright idea today that didn't quite work out. Or maybe it is working out but requires me to change a habit. I'm working on a form that will be a sub-form of another form. During initial development, I find it easier or better to work on the form as stand-alone entity rather than a sub-form. One reason is that I can edit the form...

How to check if No Value was selected from List-Box without using any built-in Events ?

Dear Access 2003 users, Can anyone assist me with creating either code (preferred) or a query that would remove a single field (called ID) from a table? And as a bonus question, can anyone assist with adding a field (called ID) to a table and then make it an Autonumber data type? I've been successful in adding the field via code, but...

Hello, I'm into DB access now. I have a SELECT Query code here: Public Sub DBSelectUpdateListTable() Dim db As DAO.Database Dim rs As DAO.Recordset

HI: I see the term "Me!" in a lot of Access statements, bit don't quite know what it means. In the same contexts as wondering what the meaning if "is" is, I wonder what the meaning of "Me!" is. Can someone enlighten me? Regards

I'm new here and will admit right off the bat, most of this is above my head, but I like Access and learning the ticks of the trade so to speak. Here is one and I’m sure there is a way, but I’m stuck. Below is triggered when a button is clicked in a form: DoCmd.TransferSpreadsheet 1, 8, "Employee", "C:\Manager.xls", True The “Employee” and...

I have been searching everywhere to try to figure out how to use Access to open an existing Word document that is merged to an Excel spreadsheet and merge the data when it opens. I'm working with two different version, Word 2000 and 2003. I got it to work perfect in 2000, but when I use it in 2003, the Word document opens and it is not linked to...