Search results

I have this code to ask for a PW to get to the next point. When I enter the password I can see " hey! " ... is there a way to make the pw show as **** when it is being typed in? Dim strPassword strPassword = InputBox("Enter Password", "Restricted Form") 'Check to see if there is any...

Thanks, so is there a trim function that can trim trailing spaces even though the characters in the field are different lengths?

I have tables that get their data from SQL server. Some of the fields in the table have trailing spaces. Does this issue need to be resolved in SQL server or in Access?

Alright thanks!

Wayne thanks for the suggestion! I actually first started out doing it like that, but the setup of my database doesn't conform well to that so I just changed it to open the parameter window. So other than an Access form is there any way to format the parameter window?

I have the following query. SELECT Table.*, Table.Date FROM Table WHERE (((Table.Date) Between [start date] And [end date])); Is there anyway I can format the box that prompts you for the start and end dates? I would like the format to be, mm/dd/yyyy ? Any help?

I know how to do parameters for a query. I want parameters from windows and not from an access form. For example vbOK that asks you for date start and date end. If this isn't possible just let me know and I can just use an Access form like I was doing before.

edit: nvmd

No, but we have a lot in common. A lot of people use us everyday... :mad: lol

wow that's crazy. 2 years ago that could run you $300.

I'm looking to buy an external HD since I've seen prices drop dramatically this past year. Anyone have any recommendations on at 100gb HD? Right now I'm leaning towards Maxtor or WD. Links to cheap external HD would be great! I'm in the US btw and I'm looking to spend <$90

This guy named google can tell you the answer

count: count(*) will that work?

no clue, maybe someone else can help. It should work, maybe try split up the db again or manually link the tables yourself and export all of the objects.

what is .accdb? shouldn't it be .mdb? The FE has no visiblity on the BE so check the file path

What is the exact error?

I recommend you reply instead of editing the original post. This helps other if they have the same problem. Your tables are linked to the FE right?

Well is the E drive on the network? They need visibility on the BE.

The problem was I didn't know what to look for. I didn't think a union query would solve this. For one I don't know what a union query is or does, but now I know.

Yeah man, I googled "access list box All" and I was taken to a bunch of things that were irrelevant.