Search results

I'm working on a timesheet database including addenda (additional budgets). each item is associated with an addendum, which is associated with a project. on my time item input form, i'd like two combos. one for the project, and one for the addendum. each record in my table of items is linked...

I have some ideas on how to do this, and with which events to trigger it, but i want to hear other people's thoughts on it: I have a purchase order creation DB with a table of standard parts... about 350 items. orders can also include custom 1-off items, so i decided to simply add them to the...

when i import a spreadsheet into a table, there's one column that contains multiline data. for some reason, in the imported data, hard returns (alt-enter) are converted into squares, and the line breaks are in new places. any idea how to avoid this? or how to go through programmatically and...

I've downloaded and installed the new SQL server 2005 express edition CTD (June ed.) along with the Express Manager. How do i get an access database into SQL server? Now that it's installed, what next? When i try to upsize, it asks me to choose a server, and gives 3 options, and i'm not sure...

this doesn't actually have anything to do with access, but the vba code would be the same if it were... and yes, i really do need the code to wait for excel. i'm exporting data from another program (solidworks, actually) and creating reports in excel. in my options form, i allow the user to...

I've made my own record navigation buttons on a form. they work fine, except when i get to the first record. if i click 'previous' then the 2105 error pops up "you can't go to specified record". the buttons were created through the wizard, and have error trapping in them. for some reason, it...

I've got a report that includes a pie chart created through the chart wizard. the source data for the chart depends on options set in a form. to change the source data, (in the OnOpen event), i create an SQL string and then i have the following line: me.objGraph.rowsource = SQL once the code...

I have a listbox, and it's underlying query includes a group by / sum function pairing. because of this, it's recordset is non-updateable. I need to select an updateable recordset for which that calculated field is in a certain range (say between 0 and 1). what i'm hoping for is to use the...

Database: Invoices.... need a billing address, and a delivery address. I have a table of addresses (of both kinds, of course), a table of invoices, and a linking table for the many-to-many, because each invoice has a delivery address, but may have a separate billing address. in my linking...

i've attached a small database (not all parts work, but the relevant ones do) showing a client/contact selection system. the listbox shows results of the search from the fields at the top. if you click on the second or third contact for a client, it brings up the client properly, but for some...

here's what i have: IIf([Forms]![frmJbBk]![chkIncmpltJB],>0) it doesn't work. if i replace it with just >0 it works, but then i lose the option of hiding those records (obviously) how do i format the >0 to get the iif output to work in the criterion?

I need to create a button on one form to open another form to the same record. i've tried using the wizard, and everything looks like it should work, but it doesn't. the form still opens with a blank recordset. the field i'm using to link the two is the autonumber index of my main table (which...

In my main table, each job has a value. over time, it can change, but i need to retain the original value, so i have another table that tracks the adjustments to the value. this of course, leads to a calculated field on my forms. I have a search page on my form that includes searching for the...

I'm building a string of criteria with a public function, but can't get the query to recognize it. i've stepped through the code, and it should work, but i can't figure out the syntax to get my query to recognize the criterion. well, i may as well describe the whole situation. i have a field in...

I have this ugly criterion for a date range: Between DateSerial([Forms]![frmQtHst]![txtYear1],[Forms]![frmQtHst]![cboMonth1],1) And DateSerial([Forms]![frmQtHst]![txtYear2],[Forms]![frmQtHst]![cboMonth2]+1,1-1) frmQtHst is the Quote History form, which allows the user to select a range with a...

I'm working on a Purchase Order system, and on my search page i have a check box that selects wether or not completed orders will be included. I have a 'required' column that lists the number of items outstanding on each order. i need an if statement that determines wether the query selects all...

I have a report... that includes a text box in the middle of the page for comments. on formopen (and form activate, just to see if it works), i have the following code to hide the text box if there's no text to go in it. If IsNull(Me.Comment) Then Me.Comment.Visible = False i have two buttons...

I'm using a notinlist function to add a contact on a form. each contact is associated with a client by selecting the client from a combo on the contact entry page. when the contact name is being entered, the client is already selected on my form, and i want the combo on my contact entry page to...

I have a main form with a subform for creating purchase orders. in the subform, details for an order are entered in datasheet format. i have a problem with a quantity column. if you click in the cell and type 15, it doesn't overwrite the default 0 and the result is 150. this is bad when you want...

note: all following table/field names have been changed to protect the sanity of the reader. I have a main table, which includes 3 potential positions for a person to hold: pos1, pos2, pos3. each field is linked to the same table, which holds a list of people. in my back end relationship...