Search results

I have a query which returns selected rows from my table, one of the columns in the table is price. I want to total the price into a text box on the form and run the query in the 'on current' event of the form so it recalculates depending on the record can anyone give me a pointer please? thanks

Hi I am in the middle of developing a DB which will be multi user. My boss wants to install a Citrix server over the next few weeks. He has now asked me if we can pilot this database with the citrix server. Can anyone advise what (if any) pit falls I may be in for as we head down this route...

Written in Access 2003. This database was written to produce lables with 128b barcodes on, but could be modified for any other standard. It is optimised for an A4 sheet of labels with 8 per page. It has the ability to skip used portions of the label sheet. It also counts how many lables are...

Hi I am writing mini database which will produce labels for boxes. I want to be able to produce a sheet of labels based on the 'number of labels' to print field. I can output one label or many on the page/s depending on how I structure the query and how many records are in the query. My...

Hi I am using the following code on a DBL click event to move to a new form and open an appropriate record, the problem i am facing is when the company name has an apostraphe in it ie: [two o'clock] the code falls over. i think this can be solved with bracketing.... can anyone help me with the...

Hi, I want to fire an event that will automatically, set a date 45 days into the future based on a recorded [datefield] in my database. However, I want to know if this date falls on a saturday or sunday and if it does, return a warning. can anybody point me in the right direction to get...

Hi, I think i am being a bit thick, all I want to do is create a report of projects without products.... I have a table of Projects (customer name, details etc...) I have a table of Products (product name, config, details etc....) Every project will eventually have one or more products...

Hi, I am using an SQL statement to insert a 'User Notes' string into a record in a table. However, if the strings contains a (; semicolon) or (' appostraphe) it messes up the SQL. I put this into the onKeypress event to try to capture/combat it.. If KeyAscii = 59 Then MsgBox "Prohibited...

Hi I have a simple form with a single unbound text box which captures a 'user note' string and theoreticaly could be null when the command button 'on click' is fired i have put the code: If Me.Text1 = Null Then GoTo cont: ' ' ' ' more code here! ' ' ' cont: MsgBox "No User Note Entered...

Hi, I am trying to use an 'INSERT INTO' sql statement to write values to a table. I sucessfully used this statment in another part of my database to write a new record. I have copied the code and substituted the values, fields and relavent strings, but now i am getting a syntax error. The...

I have just created an append SQL string that adds a new record, sql = "INSERT INTO tblAncilleries ( ProductID, PartNumber, ProductDescription ) VALUES ( " & strProductID & "," & strPartNumber & ", " & strDescription & " );" DoCmd.RunSQL sql How do I suppres the dialog box - see jpg? Thanks

I am trying write to a table the resuts of a selection from a combo box using the following SQL. can anybody please help me with the correct syntax for this as I cannot get it working, and it's throwing up a syntax error. Thanks Dim sql As String Dim strPartNumber As String Dim...

Hi I have a form with a subform, the subform is in datasheet format. How can I populate the underlying table of the subform with the data selected from the combo box on the main form? basically each selection from the combo writes a new record to the subforms table. I can capture the data...

Hi, I want to open a subform programatically with a 'linkcriteria' filter. However, What i am experiencing is just the subform opening without the main form. How can I open the subform on the appropriate record and the mainform as well, as one?? Thanks

How would I go about creating a datasheet style form with 'sort by' headers for example: I could create a form with a list box sorted by 'name' by default. If i wanted the same data to appear but sorted by 'Address' or 'Phone Number' how would I go about this? Many databases give a datasheet...

Hi In my database I have certain fields which when dbl clicked move me to a new form. What code should I be researching to make sure that the forms field values are committed to the tables before opening the new form?? is it: docmd save or a recordset.update? thanks

Hi I want to populate a combo box based on a query, based on a table. The table has several hundred rows. The column I am interested in, although having several hundred lines to it, essentially has only 4 products listed. How do I set my combo box to return just a list of the 4 products and...

Hi I have a form which displays records of our products, on that form I have now put a list box which displays the ancillaries to the products. both the form and the list box run off queries. I have the same unique identifiers in both queries. I need to filter the listbox by the unique...

Hi I want to have a table of 'database defaults' in my DB each of the defaults is a setting that applies to all of the DB how do i relate this table to the rest of the relationships or more simply how can i pull in one of these default settings into a calculation? Example: I am trying to...

Hi, I am putting together a parts database for our products. I want to use cascading combo's to select all the availible parts for any derivative of our products. I'd like some advice before I start, If anyone can help and forsee any problems down the line... I imported a parts catalogue...