Search results

I have a form with a combobox that queries a table, when i make my selection a form opens to the appropriate record, but now my form is a tabbed form. How do i open that form now basedon my selection? Thank you

I need help on how i can convert 1184 days to years, months, days. thanks

I need to manage a list of, in this case "medications", with this list the most common "meds" are on the top of the list. there will be at times new "meds" added that should be at the top of the list. I want to create a unbound box that will let me drag the "meds" up or down in the list. The...

:) I'm having problems with a simple piece of code using datadiff. all i want is to know how days from today is 3/10/2006, which obivously will countdown as everyday gets closer. joe

I have a report that was being sorted by an option box which allowed me to select which filed to set the sort by option. I had to make a changes to the report design to group by "Property Address" using the Grouping and Sorting options, now when i select a different sort option in my option box...

Ok here is my problem, i have a report selection form which help generate report based on all types of criteria, the one problem i have is when i i don't fill in the Agent box(see snapshot)(left empty) i want all agents on my report. here is the sql code i have. I have tried various Iif...

:cool: I have used this code and it works perfect, but i have one issue. I want to be able to sort the reports, for some reason this code randomly sorts and ideas? Private Sub Form_Load() Dim objAO As AccessObject Dim objCP As Object Dim strValues As String...

I have a text field that does not contain any carriage returns, but when i use OutputTo .rtf i get i get the export with returns. any ideas how i can do this?

I noticed recently that when i open an mbd i get two pop-ups, that are installing something, then i noticed that in the task manager i have a msiexec.exe running that is getting created when i open a mdb(any mdb). I did a repair and a compact database and that did not fix this issue. Does anyone...

I have a report i want to open only showing records by a date range, now i have a query that prompts the user to enter the date, but that looks terrible, how can i have a form come up with two date s fields start and end, then pass that criteria to the report without using a query?

I'm looking to update a field in a record without using an update query, resaon being i need to make create a run time out of the data base and i don't want the program to prompt the user that a table is being updated. any suggestions?

I am looking to print out a list of all reports in a mdb, even tables or queries. Any ideas anyone?

I want to open a form to a specific record based on a value i enter on another form. The first screen a user sees they are asked to enter a lastname or phone number to find a patient. All i want is to have the form open to the patients record. Please help driving me crazy.

I'm looking for a way to disable the delete record command from my users, my end users are using a run-time version of access. Any suggestions?

Hello group, What i am trying to do is have a form with combo boxes where the user selects their own criteria and feed the query to get a custom report. I have so far manged to get only exact matches to work. but let's say perhaps i need to leave one field blank to retrieve all options, i get...

I need to inport this file into a table, but having troulble with the code. I would like to use the first part of the line as the table header using the semi colon to separate fields.

I need to be able to update a field on a form that is created by to linked tables.

I'm looking to make a combo box mandatory. Users have been leaving it blank. Would also be nice if the code could check to see if the box matches what the combo list as available. Thank you still learning...