Search results

I came up with a solution, I made the report go off the information that came out of a query. In the query instead of having 3 seperate areas for the account number (brnch, dlr, contract) I turned it into a string: AccountNumber: [Branch] & "-" & [Dealer] & "-" & [Contract] so that way it...

Yeah, how do I go about switching this so I can get the report to do what I want?

Do any of you guys know how when exporting a report to excel to make it include everything in the report, right now it is cutting out the zero's if they are first (e.g. 4-101-5690, when it should be 004-0101-05690) I am thinking I have to make a excel template and somehow get it to export to...

Does anyone know how to go about this or know previous thread stating how to go about this? I have a Follow-Up labeled Text Box (Short Date) and I want for the associate to be able to set a desired follow-up date and for the account to disappear from the list afterwards till the follow-up date...

well nevermind... simple as docmd.openform "commentbox", acNormal I swear I wanna slap myself sometimes.

I am using a lablel as a custom command button that when double-clicked it will pop open another form to view all comments/notes made on it, rather than having to scroll the small comments line I have in the main form. I have it working off a macro right now, but I really do not like macro's...

I know how to change the color of the font of the command button, but saw nothing in properties on how to change the color of the button... is this at all possible. If you need a reason, it is for designing preference really.

we actually have a standalone dbase that allows you to browse for the mde/mdb you are needing to disable/enable shift and f11 (all the special dev keys)... it is pretty handy.

Yeah I think that is exactly what I am doing. I am creating a module for my menu so when they press it will do the import. I have created a Import Specification that pulls what info I need out of this txt file and will put it in my table. Should work.

I am trying to import into a table a very large text file that has information dumped into it every morning from a daily import. I am building a database that is also using the same information but on a stand alone database and was curious to know if there is a way to link the txt file to a...

What is happening is even though you are just updating the exe with a new version you are literally making a new .exe; since they installed on the previous .exe they would have to use that same one to install/uninstall it from the program rather than add/remove programs. What I would suggest is...

Should also look into setting it up with an auto-update feature for everytime you make a new version or update, which is pretty time consuming but when you get it, you can use it in all your future databases and it makes updating so much each

Hehe, always gotta make sure you debug it first.

Basically the backend of the database is just the information and no form of GUI(forms). The frontend is the graphical part with the user in mind using linked tables from the backend source. Fortunately Access is designed for multiple users so you do not have to work about the network part...

no idea why this went twice, sorry bout that. Admin if you are around please feel free to delete one.

I was way off. Should be If Len(Me.Branch.text) = 3 Then contract.setfocus No End If on this one or it will crash out on ya. Of course "branch" and "contract" is whatever your text boxes are, pretty simple.

I am needing to know how to get an access report to export to Excel in the format I want, right now when I do it... it just doesnt look very clean. Is there a way to set it up to make the colums already spaced out and whatever else I want to do with it everytime I export it?

I am needing to know how to get an access report to export to Excel in the format I want, right now when I do it... it just doesnt look very clean. Is there a way to set it up to make the colums already spaced out and whatever else I want to do with it everytime I export it?

Gotta remember that if you do something with your toolbar it is local and not built to the database, you can create a custom tool bar, and the set it in TOOLS > STARTUP so that it shows for other users.

Also if you want a total of those in your report, you can put this on the footer or where and create a new text box and set the control source as =Text# (# being the text box you used to do the number scheme) and it should pop out a total.