Search results

I am working on a database that will go to a website and download a specific file each day. So far i have everything worked out except the download dialog. I can navigate to the website, tell it which file to download and then i am prompted with the download dialog box. Is there anyway to...

Is it possible to compare the current value to that of the one above in the detail section of a report then change the color to red or something? Unless conditional formatting can do more than I know of, i don't think i can use that because the values in the fields could be different each time...

Is there a way to get the text from a command line prompt? Maybe save it to a txt file, or something? I don't need to save it anywhere, i just need to be able to read through it. Thanks in advance!

I have 9 variables that i have declared as follows: Dim EmailAddress1, EmailAddress2, EmailAddress3, EmailAddress4, EmailAddress5, EmailAddress6, EmailAddress7, EmailAddress8, EmailAddress9 As String I then have a process that loops through a string to pull out e-mail addresses that are...

Is there a way to trap a code interruption (CTL+ALT+BREAK)? I saw somewhere to trap error 2501, but it doesn't seem to work for me. The error message i get doesn't have an actual error number, it just says "Your Code Execution Was Interrupted". Thanks in advance!

I have some mouse hover effects on some labels to help my database look better. I recently tried to make a multi-page form, but for some reason the effects won't work on my 2nd page. I can press page down, or use docmd.gotopage 2 and the effects won't work. So to test things out, i added a...

Hello Everyone! Forgive me if this has been addressed, but i couldn't seem to locate what i was looking for when i searched. I am developing a database that has various e-mail functions, and the reference is causing problems whenever i push out an update to my users as i have a newer version...

Hello, I have a question about querying some tables that i have linked through ODBC. I searched through the forum, but was unable to locate anything that helped me, please excuse me if i missed something. I am trying to create an Access front end for user to query our AS400 through ODBC. I...

Hello, I am curious if there is a way that I can run a query to validate the data that I have imported. For example, If I am looking for 15.00 and they give me 15, i want that record to show up in my query. I searched around a little but was only able to find This thread where someone had the...

Hello, I am not sure if this is possible, but I am running an update query to add text in a field if a certain criteria is met. However, if the field I am adding to already contains what I am trying to add, i don't want it to add it again. Everything works fine except the IIF statement in my...

As a continuation from this thread... Currently, I have a list of programs, each program could be considered the "task". When the task is completed, I want the user to click the date on the calendar and have it grayed out. As I mentioned before I have this working correctly, but I have the...

i have a listbox that displays a number, and a date in one row. the number is in column 1, the date is in column 2. is there a way to get the sum of the numbers in a text box? Thank You!

I have a list box on a form, that i want to be displayed on a different report. I just want it to list exactly what is in the list box on the form. shouldn't it be as easy as setting the control value on the list box on the report to the list box on the form? I tried...

I have a report that looks like this: column1 column2 column3 column4 item1 1 5 7 3 item2 2 6 9 4 item3 2 5 1 9 total 5 16 17 16 the calculations for the totals are all done in the report using Sum([fieldname]). I need a way to pull the top 5 values from the total line. is that possible...

I have a pop up that i take info from, and when i close the pop up, it puts that info in my main form (using onclick before it closes). This works fine. I am trying to redo my database, and in the process, i started using subforms. I need the same thing as i have above, but the data from the...

Everytime i set anything under the timer event on my form, i get the following error. I am trying to implement a progress bar, which i have working fine at home. tried it at work and got the above error. then i realized this error would pop up anytime i had anything (even as simple as...

I am trying to use the example from this thread, but i keep getting a run time error. The error i get says invalid property value. the line i am getting the error on is: ctlProgBar.Value = intCount Any ideas? Thank You!

I am trying to make a colored form, and i have changed the backround color in the detail section, but i still get a gray line on the right side (where a scrollbar would be), and across the bottom (where the records are). Is there a way to fix this so it will be the same color as the detail...

I am trying to use the calendar from this thread, but my dates are in a different format. My dates are in the format 20040826 because they are run from an AS/400. is there anyway the calendar can recognize this format so when i click on a date, it will enter it (in the above format) in a text...

I posted this in another forum, but not getting a response. Thought maybe someone from the report forum could help. http://www.access-programmers.co.uk/forums/showthread.php?t=67363 I need to filter the data from the example in that other thread to a subreport, but i am not sure how. Thank...