i am looking for the best approach to limit the current user to only edit those records that they are assigned. I still want to view all records, but somehow prior to change of the record - a...
Need help with syntax.
" SELECT " & chr(34) & gid & chr(34) as Tech_Grp_Person, Task_Description, Requested_by, Need_Date, Work_Estimate, Planned_Start, Planned_End, ECD," ...
What VBA code do I use to access the various regional settings on the PC on which the code is being run. Specifically, I am looking for the Time Zone.
I have 2 forms:
frmHistory
frmHistory-sub ---which is a subform of frmHistory
View Selector
When I'm trying to open frmHistory I have error message 2450 can't find a form "View Selec...
I am using Access 2000. I have a form. On that form is a button titled: "Print Report". When the report opens, if a user shrinks the report the background form shrinks with it. How do I preven...
I have the following attached code that looks at a file on a network drive. I get File and/or Path Not Found, but the code works fine if I have it look at a path/file on my c: drive.
What ...
Experts, right now am using VBA to automatically run a query that creates a table with subdatasheets. The program then automatically exports the primary table to excel. My question is, how do ...
Hi Experts,
I need to pop up a form as a dialog box to allow users to key in information that later will be written into Access tables. How can I do it using VBA? I want this form to be inv...
I have a routine in Access that creates a table on a PowerPoint Slide. I have attached a portion of my code. Instead of applying the font attributes to each cell in the table, I want to do i...
I need from excel sheet (button on click) to import the data from another access app table
What do I need to change in this code to make a popup appear within the access environment instead of a new internet explorer page?
This link provides more details, the solution there did n...
I have a form(Name"Old_Date") On this form I have a textbox(Name: "Date")
I also have a table(Name:"Date_List", Columns: "Dates")
How do I make it so that when I press a button my textbox ...
I have a MS Access table call tblTest: Sample data like the following:
PID Visite Code1 Code2 Code3 Code4
111111 1/2/2007 1A 2A 4A 3A
111111 2/2/2007 1A 3A 4A 5A
111111 3/...
Perhaps an ODBC issue, but after user does the FileOpenSave and navigates to any drive/subdirectory outside of the "default application path", the combo box on the same screen can no longer 'f...
Considering I have a very busy form and want to avoid making it any larger, is there a way to code the F2 shortcut within an OnEnter or OnClick event of a field? I'd like the user to have mor...
Looking for the best approach to open a File dialog, so that the user can select doc, xls, etc and place that data (filename, filepath, and attachment type) in a listbox(underlying table), the...
I am relatively new to VBA programming. I have a form in an ACCESS 2000 Database that requests a start and end date to pass to a query; the results of which are to be transferred to an Excel s...
Is there a way to retrieve a sibling to an xmlnode using MSXML2? My code looks for 'part_e_pag' nodes and puts them in a string arrray. Then looks for 'sme' nodes, and populates a combobox wit...
Hi, I have a make table query [qryOutput] in Access that filters results when a user chooses the criteria. When the form [assessment] filters the data I would like a command button on it to ex...
I've got a form that opens very slowly because of the recordset queries that are run on the On_Current event. Is there any way to allow the form to open and let the code run in the background...
We have a database that has a few custom buttons that have some event procedures programed in. Some are simple close window, some open a graphics program like Ifran to go to a Tiff file.. mo...
I have one Access macro with lots of macro names in it - i want to put a list of the macro names and comments into a combo box for the user to select from...
Ideas?
Thanks :)
I am afraid this is beyond my vba knowledge. I am trying without success to write vba code to export query data (Factfind Query) and (presentation query) into a 2 page spreadsheet (sheet1 Fac...
I'm trying to set up an auto-run macro to export my data as an ASCII pipe-delimited format. Anyone have ideas on how i could achieve this. Data export format:
- Ascii file (pipe delimited)
...
Hi experts,
I have created an SQL inside a combo box that displays values relating to a location reference. This works ok but I would like to have an "ALL" in the list that can be selected...
