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 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 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 ...
I use a routine to call a chart in a form. When it is first called the graph layout is messy, with the legend overlapping the plot area.
However when I step into the code it draws neatly. I...
Hello Experts,
I'm using SetValue in a macro to store a number for calculation. The calculation is being done in a query and the number for the numerator looks as follows... #FCbySept15: Fo...
I have a field as
MT 0234-234
MT 234
MT 234945
MT 384322838439
what I want to do is keep the first two letters from left and delete the rest. How would I do that.
Thanks
I have 2 tables, each with a date field, where these are specfied in the table design as dd/mm/yyyy in the format section.
The first table is displayed on a form, where the date field is ag...
Is there a trap-able event tripped by the cursor moving through the rows of a listBox - such has happens when the up- or down-arrows are used to navigate from one element to the next without m...
I want a splash page (Bitmap) to open up first before the autoexec form loads on my access db. I think i need to use the timer event, just not sure how. Just for 2 seconds or so.
I'm using the exact same piece of code over and over in every one of my forms, so I thought I would give making a class a try.
However, despite reading several tutorials, none show *how* to...
I have the following routine that works as long as the field name I am looking at in the RecordsetClone is "Portfolio":
Public Sub Reset_Filtered_Chart(strFilterValue As String)
With P...
The attached code sends an email when the button is clicked. The body of the email is all strung together. Is there a way to put in extra lines in the body so it's more legible?
I have a query named TasksLogPeriod created by hnasr, that does calculations for how long a each task has been active and inactive. Using that data, I have created rptTasksLogPeriod intended ...
I need a report for the length of time each task has been active based on the three (3) queries, TasksLogActive, TasksLogInactive, and TasksLogPeriod. The queries were developed by hnasr for ...
I want to open Excel from Access, as if I was double clicking the .exe file.
I actually want to open a specific excel file in the process.
I do not want to create an object in Excel to do th...
I have a login form that allows the user to enter the system. Once you gain access, it opens a form (Search) to login to access a record. I would like to tie the user that logged into the fi...
Is it possible to update and/or add VBA code, Macros, Forms and Reports in an Access 2007 DB that is in runtime mode (.accde)? We want to be able to make changes to the screens and reports bu...
I would like to dynamically assign field names using a counter and loop through the fields of a record in a DAO recordset. Here is an example:
Dim dbs As Database
Dim rs_RIA As DAO.Record...
Hello,
I'm trying to insert "PCAC" into the destination table and for some reason I can't get the syntax correct!
Trying to get the right syntax to run this statement in vba. Need help to determine double quotes, single quotes, etc.
strSQL = "Select * from qryBuyerReport " _
& " wher...
Can anyone out there recommend a good rich text control that can be used for text and memo fields in Access 2002. I want to have bold, underline, colour, bullets, ect... available to me for so...
I have a text box with the code
DLookUp("Month 1". "tbl_revenue", "[MID] = #" & Forms!frmreporting!subterm.form!txtMID & "#")
However for some reason it wont work.
i get an #ERROR d...
