Search results

to fill the provider box: youll want to check to make sure everything is working as follows: after building the SelectString, either print it out or pop it in a message box to make sure the string is built properly. if it looks good, try testing it in the querries tab. (to do this, in the...

hey, whats up. first, youll want to make sure your tables are set up properly. im not so great at this part, but i believe youl want three table as follows (if im wrong, someone chime in): tblProgram (with ProgramID (autonumber) column and ProgramName column) tblProvider(ProvidorId...

when you say you want to assign it a default value, do you mean when the form loads, the combo box should have the first item selected: if so, do this: on the form that has the combo box, goto the events (open form in design view, double click to view its properties and select the events tab.)...

hey guys, im trying to design a database but i am still learning best practices. can anyone help? heres the data ill be collecting and how im going about it so far: part 1: one table will hold all Districts (each unique) one table will hold all facilities in each district (each district can...

hey guys, im trying to design a database but i am still learning best practices. can anyone help? heres the data ill be collecting and how im going about it so far: part 1: one table will hold all Districts (each unique) one table will hold all facilities in each district (each district can...

i think im missing something i must be missing somethings. ive tried that, for most key presses i can capture the event but some event (like alt+f11 and cntl+f) are not captured. i set keypreview to on and selects the keypress event

im trying to capture all key press and multiple key presses for a form (ie. cntrl + f) and assign my own action to it. i want to be able to prevent all office actions from occuring (for instance if you press ctlr+f the windows "find and replace" dialog pops. i want to stop this action and...

refferencing sub form controls i believe that if your are referencing a control on a subform you cant use "me.control". try refferencing the control like this: Forms("MainForm")("SubForm").Form.Controls.("SubFormControlName").

the million dollar answere im currently working for a research group. every few months they need to create questionnaires (which they will use spss to do data analysis on so it has to be in access so they can export to spss). right now they have to pay someone to create the new...

use count sql use the sql count function and run the sql statement with docmd.runsql ex: you ll have to edit the sql string to fit your table

what if you filled an array with your data set then pass each row? if this would work use the "getRows" method. this method will take your query and fill an array with the results.

hey everyone, im having some problems with CreateControl method. i have a function that is called when a button is clicked. what i want this function to do is create a text control on a tabcontrol page. it will be called from a button press event (the button is found on the same form as the tab...

i use freehostia. its free and supports php/mysql. theres no forced adds and the support is decent. they were having some issues with servers going down but that seems to be better now

or also, you may not need to pass any data. if you know in advance what pages are valid you wouldnt need to use php or a database. just do it all in javascript (although this would not be a secure option). just read in the value through the field, compare it to an array of correct responses...

you know, i has a similar issue, so i created a form that was a calander. i created it so taht by clicking on each date you could add an appointment, which would be stored in a table. everyone loved it, although it was a bit time consuming to create but worth it

ive created a program and now need to make it 2007 friendly. i have my own custom menu bars for my forms and reports. when they load in 2007 the ribbon has my menu bars as well as all the other default ones. how do i remove, or hide, these groups from the user. i dont want them to have...

im trying to import a file (any file type that can be exported from a query), programatically, into either an array or querry. i need to have in in an array or query so that i can check the structure before i insert it into a table. anyone know how to do this?

hey guys, was wondering if someone can help. heres the scenario: im creating an application that will be used my many computers in an office. because the office is not networked im creating a import/export form that will export a table to an xml file. then that file can be brought to another...

hey guys, i was wondering if someone could help. im currently serving in the Peace Corps (a two year voluneer program working with community development, hiv/aids, etc) in africa. i designed an application the government would be using in all of its social welfare offices. im not getting paid...

no, it has to be updatable. anyone else have any suggestions?