Search results

I have table with multiple columns that identify a location (ie. city / state / Country) that I use for filling in data on an Access 2010 Web Form. I would like to be able to pick a city and it auto-populate the state and country. I was able to do this easily on a client database but am having...

I have an Access 2010 Web Database deployed to SharePopint via Access Services. In my data entry form there is a comment block that needs to be updated based on a new entry to a test box. I use a button that inserts the Date and Current user in front of the text bos entry and then adds the text...

I have a help desk database with a customer search form that pulls up all tickets submitted by a customer. The subform (tickets) is currently linked to the customer form based on whose record you look up. I would like the subform to come up showing all tickets for the customer and have a list...

I have a database that tracks help desk tickets. The table that carries the data has a corrective action field which when updated added the new comments to a History field that shows all comments with a date stamp. The form that opens the record for editing opens with all fields prefilled as to...

I have an access 2007 database that is used to log help desk tickets. On the ticket screen there are tabbed pages used to seperate areas of the ticket. Is there a way to prevent the tab pages from stretching when the database is opened full screen.

I have a multi feild search form that pulls the filtered results to the bottom of the form when the filter is applied. What can I add to this code to send it to a report (AdvSearchReport)? This is the code I use on the page: I have removed a lot of the search fields from this version to make it...

I have a form used to input Help desk tickets. On the form there is a choice to select a customer- what I would like to do it auto populate another field on the form based on the customer. The "Customer Field is pulled from a seperate table and I would like it to populate an account Number field...

I have a subform that pulls up the results of a query that is then filtered by the users to get the data they are looking for. My question is how do you take the filtered results and send them to a report or file so they can be printed? Any help would be great.

Can the enable Macro and VBA button that comes up under the ribbon be moved onto a popup message. My database hides the application window so I would like a popup that would allow the enabling of macros and VBA instead of needing the application window to do it.

I have a split form for a Help Desk ticket database that shows the ticket input form at the top and a complete list of all tickets at the bottom. Is there a way to allow the top form to function as filters for the bottom list so a user can search by one or multiple fields? And then once filtered...

I'm still trying to get my mind around the VBA coding but here is my question. I have a log on form that verifies a user based on a user name and password table. How can I save the log in name for global use in other forms - i.e. to recheck permissions based on admin or not so that an...

My database currently has interactive reports that allow the viewer to open a record for update from the report. My problem is now that I have successfully hidden the application window from the users so they cannot change the database except by using one of the forms the reports will no longer...

I just posted a similar post in the reports forum but thought maybe it was related to the form setting itself so thought I'd post here also. I have a database that opens to a log in form with the access application window hidden from view. I can get from my log in page to the first form with...

I have a new database that opens with the application window hidden. It starts by opening to a login page, once logged on it goes to a form with buttons on it to open otgher forms for database entry and some buttons for opening reports for the database. My problem is now once I click the button...

Is there a way to enable the macros and VBA coding when the program opens without having to do it manually? My database opens with the application frame hidden so users don't get the message to enable the code. It is a multi user database that is accessed on line.

I am fairly new to the VBA coding in access and would like some help with a log on form I am using for my database. I have the following code that works fine for opening the form I have mentioned but would like the code to break it out a little further by checking to see if the admin box...

I have a database that opens to a log on form without the application frame in the background. Is there a way to make the form auto center on the desktop when opening and possibly resizing based on screen resolution so that the database will work the same for all users no matter what type...

I am looking for help with a login form with user name and password for access 2007. I found a nice example database that was using the CAPICOM.dll fro encryption but Windows 7 does not support CAPICOM. Does anyone have another example of know how to replace the CAPICOM in the present coding. I...

I have some code from a sample database on this site that windows 7 does not like because it no longer uses CAPICOM.dll. I am new to coding in VBA and need help replacing this with something that will work. It is from the LogonSystemDemo in the sample database area. Public Function...

Is there a way to hide the main access window and only show the form or report that is selected. I don't want the users to see the program itself or be able to get to the data without using the forms that have been designed. I have built a database to replace an old one that used ASP pages to...