Microsoft Access / VBA Forum

I need the syntax for limiting query results to either even or odd numbers, depending on certain conditions. Any help is appreciated. Thanks, ang

I have a textbox that I'm using as a search field: txtAddress. I have a query that is based on that field using the Like keyword so that I can have wildcards. What I would like to happen is that as I type each character into txtAddress, the subform (that is based on the query) requeries. Here is what I currently have: Private Sub...

Hello everyone, I hope someone is out here who can help me with a simple calculation... I have a sales data base in access with monthly sales history by product. to make future predictions I need the slope (representing growth) of monthly sales. the data is setup in a crosstab with the months in different collums, say column 1 to 12 for...

I understand that new features would not be available but is there any way I could open an accdb database in Access 2003? Robert

Hi I have been trying to convert the week number to a range of dates that I can use. It should be fairly simple for you guru's out there but for us mere mortals it is beyond our grasp. I know that there are different start days of the week so I would presume any function would provide that facility. Hope you can help Mark

I would like to open a folder from command button and I am not having any luck; ... Dim stdfile as string open stdfile "c:\temp" End sub and I am getting error because I have nothing after open, as far as I know my code can be all wrong. Thanks for helping Trevor2007

I'm getting a tab delimited file that I need to import into an access DB. The date field comes over as an 8 character string in the yyyymmdd format. Does anyone know an easy way to convert this to a date or a pre-existing function?

Is there an easy way to validate with VBA that a user entered a time value into a text box? I didn't see anything in the validation options on the text box properties. Steve

Hi, hope anyone can help with this query. Background: Subform datasheet link to a form to store updates on projects. Query: I have a datasheet where one of the field is a memo field. When text is entered the datasheet does not automatically expand to show all the text. Is this possible? Obviously, some rows may have 2 lines of text and...

Hi all, I've setup a table with one field that will hold percent values. The type is number and the format is percent on the field. When I do data entry directly into the field, I have to put in .03 to get 3%. If I just enter 3, i get 300%. Is there a way to configure the table to let me type in 3 and have it enter as 3%? Thanks!

I have a memo field that is included in some Access reports I created. Is there some way for the memo field to display nicely formatted text, with line breaks between paragraphs? Or is it necessary to export the report? I tried exporting a report by using the .rtf rich-text format (the plain-text format was the only other word-processing...

One of the most frequently asked questions here at TheScripts is: Can I replace Standard Access Error Messages with my own? The answer is yes under certain circumstances and it involves the placement of code in a Form's Error() Event and setting a specific Parameter to either 1 of 2 values. Many Errors occur while your Form is active and it is...

Dear Gentlemen, I,am a newbie for access and still learning on progress. I develop a small database called a Purchase Orders Log and I wanted to filter some certain records in a subform which is related to a certain field. Let say i.e. to filter a posting date. I want to use the combox box but it seems like difficult to handle. However I get...

I have read postings on the similar subject including the posting from 2003 shown below. This process works fine to display a single page snapshot report in PowerPoint. I need to display subsequent pages from the same snapshot file in subsequent slides in PowerPoint. I realize that it is possible to add VB code to the Snapshot Viewer...

Ugh, just can't figure it out. What is the code equivalent of pushing the left arrow button in the form.

I have designed a Database that will import data and assign values for ordering material. However I am having problems as I currently have to drop this data into an Excel sheet and apply a Pivot Table to it to manipulate the results. I believe that there is a way to do this in Access, however I have been unsuccessful. Hopefully someone out here...

I found I needed this recently when creating a file which had to be uploaded by ftp. The file extension was a timestamp of hhnnssms and the ms part was formatted to 4 digits. As the Now() function doesn't return milliseconds I used the following function to calculate it. Option Compare Database Option Explicit Private Type SYSTEMTIME...

The seoncd line in following code is always red as it contains some error. Me.Combo31.RowSourceType = "Value list" Me.Combo31.RowSource = "spvr";"mngr";"user" Please help

If I run a query that calculates the sales data for all the inventory level in a table, how do I go about saving that sales data into a permanent table? I plan I using this sales data often, and running the query each time is time consuming. Is there a way to create a new table and import the query data into it? What about the next time I...

Hi all I have an issue inserting a hyperlink into a table. I have all of the detail going into the field but it is going in as only the text of the hyperlink not the file address. How do I get the Record to read eg QSTR001 (this is the actual file name eg QSTR001.pdf) and the actual file path comes from a file picker which is working...

Hi, If a checkbox is clicked, the value becomes -1. Is it possible to change the value -1 to 1?

I have built a database with a <Mainform> and a <Subform>. My problem is twofold. 1. My subform is set as a continuos form with AllowAddiotions set to NO (ie. a list of Issues to the client on the mainform) 2. To add new issues, a button is used and a pop-up form is used to add an issue with more detail than what's available on the...

I have my application running in Access 2007. Can I use port my database to MySQL and retail Access 2007 as front End ? As this will save lot of my efforts but still get the stability of MySQL. TIA Milan.

Hi folks, We have a need to replace sub strings in certain message text. We use the Office Assistant to display help and often use the imbedded formatting commands. Those of you who have used them know they look like this: "{cf 5}" or "{cf 0}" or "{ul 1}" or "{ul 0}", etc. The commonality they have is that they are always 6 charters long...

Access 2003 - Is there any way to copy/drag data from one field to multiple fields in the same column?