Microsoft Access / VBA Forum

I'm trying to click an HTML button (to select all items in a table), but the HTML is in a format that I am not accustomed to. The button does not have a visible (at least to me) ID or name. Here is the HTML section I am dealing with... <div class= "module module-scc-favorites pkg"> <h3 class="module-header">ChartList Contents:</h3> <table...

I'm trying to create a calculation on a query where I minus 1 column of dates from another which I then need to divide between the number of records. I need to see the average time it takes to recruit an employee. I also need to exclude certain records, but would be happy if I just got the first part of this query!

EXp 290501049125 like this number field i need this to be split 12 fileds like Field1 (2) Field2 (9) filed3 (0) filed4 (5) etc. Can Any one help to solve this issue?

I have a list of part numbers that I want to search in a table. This list is imported into Access. Now using a SELECT Statement I am able to easily search and Display the part numbers that can be found in the table. str = "SELECT * INTO FROM , " & _ " WHERE . = ." This gives me a list of part numbers found. But I also want to...

Hello all, I'm currently constructing a Work Instructions database to normalize all the Work Instructions related documents. Currently there are numerous documents with different layouts. I want to reduce that to one standard format. I've already made a start on my database but during the process I'm reconsidering to change the (technical)...

Beginner here - I need to create a report that shows two fields, and . I have a table that a user inputs the into every business day. Because we do numerous calculations using the field, I need the for EVERY day, including weekends. I have created a query that displays all dates in the current year along with the for dates that it was...

Hi All... I have 27 command buttons (it's alphabet) to get Employee Name based on First Letter and to display it on List Box. Actually i got how to do it, but the code would be too long. Could be somebody here can help me to make the code shorter. The code is like below: Private Sub Command2_Click() Dim crSQL As String crSQL = "SELECT...

How to update existing code for use 64 bits systems I have created the project in Access 2007 and now upgrade into Office 2013. When I open the DataBase I get an eeror messages Thanks

Hi. I have a query that needs to pull all locations that have one score in a specific month/year (this combo will change monthly). (Some locations have multiple scores.) I thought a DISTINCT would do it but the results are the same as without the DISTINCT. I hope someone can assist. Thanks in advance. SELECT DISTINCT ...

Hi all, I'm new to access/vba-2010 and trying to set up a project database. I have a table ("Updates") that is generated when changes are made to certain fields on a form (used for project updates by the end user). It has the primary key UpdateID, foreign key ProjectID as well as UTimeStamp, OldValue, NewValue, History. I use the history key to...

I need to insert a textbox at the position of the mouse pointer in a Page of a word document whether there are text or not. I have the following code to get the position: Declare PtrSafe Function GetCursorPos Lib "user32" (lpPoint As POINTAPI) As Long 'Create custom variable that holds two integers Type POINTAPI ...

There are some combobox in my form . When the user clicks on any of them while the AllowEdits property is seting to false , I want to note him that it is'nt avilble to edit the data. I think should use the technique of class but as new in VBA cuold not find Sorry for my poor English and Thanks in advance

hi to you all am trying make the control formatting changes when changing it's value to keep track of what controls i've changed in the form,wither it was a combobox or textbox . i had this idea of making the control checks the value in the table's field which is bounded to,so if they are not equal,so i tried Conditional Formatting using the...

Hi, I'm having problem with filtering option. I will try to explain what i need on an example. I have a form with subform in it. Let say that main form contains info about single student: Name, Surname, Address, Phone number,..., and subform contains info about courses this exact student took as continuous form: English, grade, academic year,...

I Need some help in formulating a Statement. I know that I have to use the JOIN Statement but I am a Little confused on which one and how to. the Task I want to do is to find the "Project name" for an user entered "pnr". So I have a form, in which user enters a pnr value to TEXT1. Now to get the Project Name i have to go through 3 tables. 3...

I have a query based on three other queries. There are four fields in this query. These are the fields: CUSTOMER ID joins all three queries on which the query is based. The customer ID. OVER30 displays the total outstanding amount that hasn't been paid by a customer in over 30 days. CURRENT displays the total current outstanding for each...

Hi Everyone, I have a form with several unbound search controls in the header. I have two queries to get the row sources for two of those controls (combo boxes). Both of these queries reference other controls in the same form with an IIF statement to determine which records to pull. One of the queries is working and the other is not. It...

Can anyone explain to me why my function loops through 4 times when I expect it to only run through once? The end goal is to copy a record and assign a new equipment number during the process. My button click code: Public Sub btnCopyRecord_Click() If Not Me.NewRecord Then DoCmd.OpenQuery "Copy Equipment" ...

I'm not sure why, but there is a split database which regularly has fields in the sql code of front end queries change from "FieldName1, FieldName2" to "Fieldname1 as expr1, Fieldname2 as expr2, etc, etc, etc. This happens on about half the queries in the database on a regular basis. I think it is probably corruption, but wanted to see if others...

Greetings, Friends! I know it has been a very long time since I've been able to spend any time here on Bytes, but the workload has ramped up and I've been unable to share time and learn from you. So, here is the question, and it is a very strange one. Please review the following code: Private Function ChangeProperty(strPropertyName As...

I have some code that picks up some attachments and places them in an email. When I run the code it ends up being about 22 emails. Anyway, is there a way instead of when the code gets done it will go straight to the Outlook and wait there? Right now it pops up right when it gets done with each section. i = 177 cmbPSSR.Value = i ...

I have been researching this one and I'm just not sure that I'm finding what I need or that I necessarily know what to call it. I'm thinking it is sort of a partial match but the things I'm trying are not returning anything. I have an account numbers in two separate tables. I want to match the 9 digit acct number in the first table to the first...

I have a report that I want to open on Screen (OpenReport) and use a links to open the main form of the Details per Record. This works well, however I use a Select CASE in my GroupHeader0, which groups the data - This seems to be bypassed. But if I open it as a Report Print Preview the select CASE works. How can I remedy this?

Hi all, I am new to this forum and relatively new to Access. I have created an Access database and I am importing 13 tables via ODBC every morning. I am importing these tables instead of linking to them b/c if I link to them the queries are VERY SLOW. Is there a way to automate the import process thru VBA? Thanks!

I want to add several records to the subform. This works until line 4 (error 2105; can't go to specified record. Can't I keep adding records like this? Me.frmMissingItems_Subform.SetFocus DoCmd.GoToRecord , , acNewRec Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "1" DoCmd.GoToRecord , , acNewRec...