Recent content by Rob Ross

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 tried that but get an error saying I can't assign a value to that field.

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...

Can you tell me if the code that keeps the application window hidden will cause a report to not open? All forms seem to open fine but when I click a button to open a report it locks up the program without opening the report (with pop up and modal set to yes) if I mark them no then it don't open...

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...