Search results for query: *

I have an access form for user to login (username, Password) and depend on the user I want to link tables with the background sql database. In my tables I have a column to save the username at each login in time. Is there any place I can look into get some information to write this code. This...

I have an access form for user to login (username, Password) and depend on the user I want to link tables with the background sql database. In my tables I have a column to save the username at each login in time. Is there any place I can look into get some information to write this code. I dont...

thanks, this means that it takes boolean value where i can do objelementreference.focus(true); or is there a function in vbs something like field.setEditable(true); I am so used to java so, sorry if i ask none related question.

I have a form, which I have created using xml, and i use some vbscripting to handle some action in that form. I want to write a small code to activate a field to an editable mode when the user click a button. I dont VBScripting syntax that well. thanks

I have a form, which I have created using xml, and i use some vbscripting to handle some action in that form. I want to write a small code to activate a field to an editable mode when the user click a button.

Hi Everyone I have this code in a form, and I want to run few queries before the report grab data from those queries. I am not sure, if i should do docmd.openquery "queryName" but this way the query will open for the user and i don't want that to happen. Private Sub workDonePoles_Click() On...

Hi Everyone I have this code in a form, and I want to run few queries before the report grab data from those queries. I am not sure, if i should do docmd.openquery "queryName" but this way the query will open for the user and i don't want that to happen. Private Sub workDonePoles_Click() On...

I am good ssatech, thanks for the info

Is there away to hide access tool bars and menues when i bring up forms and reports. I am new to access so don't get mad at me for question like this.... thanks alot

Thanks Roy, you did it.

I have this code in a form as an action for a button, When the user hit the button in the form I want a report to showup in the screen, accoring to my code it doesn't showup in the screan but it gets send it to the printer. Private Sub poleSpecificReport_Click() On Error GoTo...

See your link table properties, my be you have to install the Database Conectivity in that computer and link the all the tables with the new database connectivity. JavaTOPerlNowVb

I get columns according to the maintaction I want to add each column. I didnt find anything in the wizard. thanks

I have this query and I want to include sum function to calculate the total of a column, I know how to use the sum function is a regular select statement but I am not sure how to add that to this query TRANSFORM Count(OBJECTID) AS CountOfOBJECTID SELECT DatePart("yyyy",[INSPECTDATE]) AS...

WOW PHV You are the best, This forum is lucky to have a smart person like you. Once again Thanks alot

Small problem, The query works, but when i try to run it from the form it doesn't work this is my large query which i run from form where all the fields get feeded from that specific form. When the user open the form, the form should be blank, form will provide the data according the mapnumber...

Thanks PHV, Thanks alot please ignore the previous post, I re-wrote the query including the way you mentioned worked fine thanks alot all you guys/ Anu

Yeap PHV I tried this still the same Like '%' & [Forms]![MainSearchForm]![MapNum_Text] & '%' Just to check if the rest of the SQL is ok, I tried this Like '%[mapNum]%')); it works I guess the syntax with the form stuff is wrong, if any of you guys have an idea please shoot a post. thanks

Gol4 Sorry to bug you it gives me an error saying "Expression you entered has invalid string" and it blinks on '%" & [Forms]![MainSearchForm]![MapNum_Text] & "%'" on where i have marked red, what could be the reason..... thanks

gol4, I put like '%" & [Forms]![MainSearchForm]![MapNum_Text]& "%'" but it gave me an error, I was thinking may be you have put extra ", but that was not the case thanks