Search results

hello... I have a form with 2 combo box. The second combo box items are limited based on the selection in the first. Everything works great on the form, except when I embed this form on another. As soon as I make a choice in the first combo box, and then try to select something in the second...

Hi I have a button that once click will send emails and should enter the date/ time the email was sent to record. But i cant get it to update the field because it states that is read only. The emails are sent with no problems. How can I get around this? Thanks in advance.

Hi guys...I can't figure this out after trying for several hours. I have table A with fields "date" "AgentID" and "Msg" Table B with has several fields, which also includes "Msg" "date" "AgentID" among others. I am trying to add the data from table A "Msg" to the matching record in table B...

Hi guys, Not sure what I am doing wrong, I have an Access dba that stores records. I create an Excel spreadsheet that pulls the data from access. This works great,but I am having problem updating the record. I have a sample that works great and I simply added the coding to my application but...

Hi Guys, Not sure if this is possible, but would like some help or suggestions. I have an Access dba that employees enter data in daily and one of the fields require a FedEx tracking number(s) be added. Is it possible to code the field that holds the fedex number that once clicked it can link...

Hi guys, I know this is an old post, but I have been struggling with this for sometime and can't seem to get it right. I have a procedure that I export to excel which worked great until I tried to add a mulit select box to the form that previously just had a date range to select from. I am...

Hi all, I currently have a form that asked the user for the date and it would query my results. But I just added a list box as one of the requirements. From the list box the user can select more than one item from the list. When I added the information in the query to reference the list box I...

Hi, I have a query that works great for me except that it returns a zero when record is null. How can I make it so that the all null values return "---" in that field? If that can't be done, I can settle for just a blank field. I have 2 queries, one uses the other to generate the records. Not...

Okay, I tried to tackle it on my own. But I think I am confusing myself. I copied the sql from my query and used that as the strSQL, but I get a compile error. I need the user to be able to select a date or between dates. How can change the vba coding to reflex this. What I am trying to...

Hello All, I have a date field that I want to restrict the user from entering a date that is prior to the 1st at noon each month. For example, If today is the 2nd of the month the user cannot enter a date of 09/30/2010, or if today was the 1st and 1:15pm, the user should not be able to enter...

I am having problem with the code below in my Data Access Page. My record source is a table and the search field is numeric. The user enters an employee id in the textbox and it should search for matching records. Currently the code belows only works when there is no matching record, the user...

Hi All, I am trying to create an Data Access Page with a search box that shows the records for matching records. I want the user to enter either the Last name, First name or Account number and the records is displayed. Can someone explain or provide and web page that can walk me thru the...

Hi Guys, I have a search form that I found on this site a while back that works great. I think it was title cool search tool. Thanks to the original developer. The problem I have is, the user searches for a customer, then selects that record. Once the record is selected the user can make...

Hey Guys, I read several threads for suggestions, and most of them ask to import raw data into a temp table then append. But thought I see if this would be possible instead. The following codes imports all excel files in a folder, and extracts the date from the file name and puts that into a...

I think I am on the right track, but I am stuck with importing the date from my excel filename. Currently the following code imports all Excel files from the directory into a table in my database. The excel files are saved like "ABC_BNG_GTR_04012008.XLS" The numbers represent the date. I need...

Ok guys, I am stuck. If I have the following codes that works fine when I separate each "IF" statement, but I was trying to combine it all into one code. When I combine the code, I continue to get the msgbox even when the criteria has been met. Please tell me what I am doing wrong. Just trying...

Hey guys, I have the below code that exports data to excel. Works wonderful, except when the Excel file opens, only the top portion of excel is visable. I would then have to save the excel file, then close both excel and access. Then once I reopen the excel file it is now visible. I would like...

Hi guys, I have been using the below code for several months to export to excel. Lately I get a run-time error 53 - File not Found. I have not changed anything, so what could be causing this issue. The debugger stops on the line "FileCopy sTemplate, sOutput" Thanks in advance. Public Function...

Please can someone tell me how to go about adding to the code below. Currently the user enters the date criteria in a form. This works great and the data is exported to excel. But I can't seem to figure out how to get the input from the user to also be exported to Cell A1 in excel. Example: if...

Hey guys, I have a database that several employees enter and updates records on a daily basis. On the 1st of each month a report is generated. What I am trying to do is have a reminder, preferable a ticker style method that scrolls across the screen that reminds them that records needs to be...