Hi, thanks for reading.
I'm writing a small bit of code to dial a phone number via our IP based phone system using a shell command to send the phone number to a program (which then does the...
I have an Access 2003 app that loops through the records from a query and builds tables in PowerPoint. But it is slow because every table, even though identical in all attributes except the c...
I need a method or function to get a value from a table for which the value lies with the range of two filelds
.
We have an array or matrix we could create in a privot table to get the value...
The debugger in VBA isn't cutting it.
I am getting an syntax error on my SQL insert statement. I first load the SQL Insert into a variable, add the variable to the watch, the string is l...
I have an Access 2007 application I am trying to prevent users from modify code/designs in. I have managed to figure out how to hide the Navigation Bar and modify/hide the (%^^$#@#) ribbon. ...
I have browsed many of the solutions here only to find bits that lead me in other directions .... what I am trying to do is automate sending emails from a Access database that we use to track ...
I have attached the database in 2003 and 2007 formats. This form behaves the way it does because of all the VBA scripting from hnasr who has worked extensively on it. Without breaking all th...
error 2391 field f5 doesnt exist in destination table modelsheet_daterange. access is trying to import some data and falling on the import because it says it cannot find field f5 in the destin...
I have been tasked with the following problem.
I need to extract the records from a table which fall within a date range with a difference, i.e.
on the 1st day of the current month i need...
Hello,
I currently have the following code which I have attached to import the spreadsheet into the table 'Age_Debt_Table' But when I open the excel sheet the first line is a generated head...
Ok, so I am creating an access database for a small business owner and I need some help. I have a lot of the tables, queries, reports and forms that I need but I need to add this functionalit...
I am using ADO to open recordsets, and my RecordCount always equals -1 even if there are records in the set.
Any thoughts?
I have an Excel spreadsheet that contains product numbers. I want to be able to highlight a range of product number cells in Excel, and In Access, run a parameter query with the values on the ...
I have a combo that I set the rowsource and I want to set the value to display first item in the drop down list.. I am drawing a blank? This is set on the fly.
Thanks,
k
I have a basic form that uploads data from a spreadsheet, populates the fields and assigns a number for the project.
There are 3 tables involved: tblPlan, tblStrPlanBldgs, and TempSPBuildin...
hi experts,
I have a function to extract information from a field.
However, some of the data does not contain the char i am looking for in the field.
Hence, i receive error in these re...
Hi,
Could not believe I couldn't find this on the web so sorry to ask. I just need to return the system date (so date at the time of running the query) as a value in a field. Can not for th...
I have created a database on MS Access 2007 on Windows XP. I will be installing it on some other XP ran computers. This database will mainly be using a form that schedules appointments for mul...
I'm creating a Search form which has the various fields from the database/tables in it. I'm using the same code/example provided in help.
However, the code only explains how to cycle throu...
That attached code causes Access to spontaneously close ("Microsoft Access has encountered an error and needs to close" message). Happens at the "Set rstOrders..." line below. Code works fin...
I need VBA code that, when activated, will check for the existence of a file and, if found, will create a new record that stores the modified date-time attribute value. The code would need...
I'm hoping this will be the last thing in this project!!
I have a macro sorting through data and redistributing it to different cells. I ran into an issue where some of the data I need is n...
Hi Experts,
I've been working with importing a csv file into MS Access and all that is working beautifully. The last thing I need to do in this import is I want to move the file once it has...
I'm having a big problem using a listbox in VBA, creating a project to be used in Outlook.
I've created a listbox with multiselection and I can't get the selected values.
The listbox is ma...
I have a couple of combobox's. When a user selects a certain items in the first combobox, it will populate the second. Depending on what they pick from the first will determain the size of ...
