Recent content by alex_aqui

I split my database and now the front end takes forever to load up the startup form. When placed on a network shared drive, it literally takes 45-50 seconds for the first form to load up. It is significantly worse at the location where it will be used (1-2 minutes on slower pc's with less...

I have a form with a datasheet subform which has users adding data on an active basis. I have the timer even to do a me.refresh and a me.requery (for update of a query for a different part of the form), but the problem I have is that it resets the cursor position on the form. If a user has the...

Sorry to have asked the question... I found the answer in a SEARCH. (My bad...). I will use the TransferText function. All I'm having trouble with now is actually finding good code from the search function that will send the file.

I'd like to send the results of a query as a .csv file to an email address. I know how to send a query as a regular .xls file, but how do I send it as a .csv file? Also, I need to remove the headers from the output. I do not want to see the column names. Is there anyway to do this, or an...

I would like to use grahpics for command buttons, but I'm curious if there is a way to get a popup description to show if the cursor is over the button for 5 secnods (ie, standard windows stuff).

I know how to do it in a report, but I'm not sure how to do it in a datasheet view of a form. Basically, lets say I have 2 fields, Status and Name. I want the Name to change to a different color (greyed out) if Status equals a certain value. On what property do I set the If statement that...

I have an unbound Datasheet view which displays data from a non-updateable query. I have a second form which takes data and appends and/or updates data in the underlying table used in the subform. This data is updated while the other form is still open. I would like the newer data to appear...

I have an unbound field on a form which has a subform that is linked to it. The subform is based on a non-updateable query, which means that if there is no match, the subform does not show up. My problem is that I am referencing some of the fields from the subform for calculation purposes for...

I would like to have a msgbox come up based on varying conditions. I plan on doing it via MsbBox "msg", vbokcancel to bring up a box with 2 options OK and Cancel. How do I read the results from this message box? Basicaly, if someone presses the OK button, I would procede with the function...

I would like to have a msgbox come up based on varying conditions. I plan on doing it via MsbBox "msg", vbokcancel to bring up a box with 2 options OK and Cancel. How do I read the results from this message box? Basicaly, if someone presses the OK button, I would procede with the function...

Is there an easy way to take a date field and add 3 to it, but in the event where the +3 ends on a sat or sun, or pre definined holiday, it adds the correct number of days to get to the first day that works? (ie, weekday, non-holiday) Thanks in advance.

I'm sorry if this has come up, but its been a while and I'm a bit rusty, so please forgive me. Basically, I have a form with a subform containing a continuous dataset with 6 columns of data. I would like to give the user the ability to sort each of those columns by either ascending or...