|
Referential Integrity problem. Related record is required in table Employee? Access2000, using a continuous form. Im getting a message that say you cannot add or change a record because a related record is required in table Employee. This occurs in all my combobox fields that have referential integrity linked to another table. I do not have the field in the table set as required, a... 6 Jul 2008 19:07
Maximise Access window I know this sounds involved, but it works ... almost I am using a Hyperlink to run an Excel application which generates a chart based on a query in the current database. This chart is saved a a GIF file is linked to an Image control on my form. ( Programming the chart object has proved far too slow) The rel... 6 Jul 2008 19:07
stellenangebote bremen Biologe Biologin stellenangebot technik stellenangebote klinikum jobs stellenangebot stellenangebot geschichte Zimmerer Zimmermann jobangebote usa stellenangebote bremen Biologe Biologin stellenangebot technik stellenangebote klinikum jobs stellenangebot stellenangebot geschichte Zimmerer Zimmermann jobangebote usa + + + ARBEITSANGEBOTE IN DEUTSCHLAND http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE http://WWW.ARBEITSANGEBOT-DEUTSCHLAND.DE + + + STE... 6 Jul 2008 14:00
Why doesn't this code work? The intent is to cycle through text boxes on a reports detail section and change the backcolor depending on the text box value. the debug.print seems to indicate that the value is coming through, but the backcolor isn't changing to correspond. here's the code: (if anyone has more brains that me on this..I'm m... 6 Jul 2008 19:07
change text box color in a report I want to change the backcolor of textboxes in a report depending on their value. I messed with this for a few hours but I'm not savvy with the syntax for getting at controls in a report. can anyone suggest a direction. For example the Textboxes would contain values like "8R", "8S", "10S", the numbers wou... 6 Jul 2008 16:03
String manipulation Hi everyone! I want to convert strings like "LEONARDO DI CAPRIO" to "Leonardo di Caprio". The function StrConv converts to "Leonardo Di Caprio" and we think it is innapropriated. Any help appreciated. Thank you! ... 6 Jul 2008 16:03
Package access into exe I have designed a database using Access 2003. Is there any way of turning this into an .exe file or package it with an access database reader for someone that does not have access on their computer so that they can still use it. ... 5 Jul 2008 15:35
Change Form Source Recordset Dynamically I have a form that is used to display patient records. It's default Recordset is set to a query which shows only current clients. I want to use an option box on the form to force the form to use the client table (tblClients) as it's source Recordset, which would display ALL clients (past and present), not just cu... 4 Jul 2008 10:00
Export large memo field to fixed-width file in Access 2007 Hi I am trying to export an Access table to a fixed-width text file. The table contains 2 memo fields of approx. 1000 characters each. I am using the 'Export text wizard' to export. In this wizard I change the default width (512) of the memo fields to the required larger size but it still only exports as 512.... 4 Jul 2008 06:55
printronix printer skipping pages plz solve the problem hi there is skipping of pages in my printer model:5210 make:printronix it is skipping pages is there any way to change the settings to stop the skipping of pages ... 4 Jul 2008 05:54
printronix printer skipping pages plz solve the problem hi there is skipping of pages in my printer model:5210 make:printronix it is skipping pages is there any way to change the settings to stop the skipping of pages ... 4 Jul 2008 15:07
jobboerse aushilfe Kinderkrankenpfleger stellenanzeigen jobboerse arbeiten im ausland ehrenamtlich arbeiten im ausland jobboerse leipzig jobboerse aushilfe Kinderkrankenpfleger stellenanzeigen jobboerse arbeiten im ausland ehrenamtlich arbeiten im ausland jobboerse leipzig + + + ARBEITSANGEBOTE IM AUSLAND http://WWW.STELLENANGEBOT-AUSLAND.DE http://WWW.STELLENANGEBOT-AUSLAND.DE + + + AUSLANDSJOBS ONLINE FINDEN http://WWW.AUSLANDS... 4 Jul 2008 03:52
an easy one (it was easy) just in case anyone else had a similar question, I figured this out by mimicking the code in another database that uses an append sql statement Mine goes as such: dim strsql as string strsql = "INSERT INTO tblPayRollSub ( Employee, PayrollID )" _ & "SELECT Employees.EmpName, (forms!frmpayrollheader!prheaderid) ... 6 Jul 2008 10:56
an easy one anyone know how to run an append (well any query I suppose) from code. I'm rusty and actually have never ran a query from code. I'm thinking docmd.runquery("query") TIA ... 4 Jul 2008 10:00
VBA ODBC Append Query I have the below code, and i need to append the results to a local table called "tblUserInfo" . The local table, tblUserInfo has the same data structure as the results. But not sure how to append the results to that table. Here is my code. Private Sub cmdFetch_Click() ''' Setup DB connection Dim cnn As... 3 Jul 2008 23:47
queries between multiple tables I'm relatively new when it comes to access but I think I have a grasp on the basics. I have a very specific problem that requires a little help from someone more experienced. I'm trying to help someone in the field of consulting create a more comprehensive database for their data they collected from surveys. Her... 4 Jul 2008 16:09
Form Data Source I have 4 queries and all 4 queries use different tables and pull different columns. Is it possible to have one Generic all Purpose form (frmGeneral) and on the fly at run time set frmGeneral's data source to any of these queries: qry1, qry2, qry3 or qry 4 before showing the form to the user? Once the form... 3 Jul 2008 21:45
open form with a different recordsource RE: Access 2003 I have a SQL variable (strSQL1 dimmed as String) that gets built using Select Case logic. The first half of strSQL1 is etched in stone no matter what. The 2nd half of strSQL1 (the condition) is built depending on which option button is chosen: For option 1, I add "Condition X" to the end of s... 3 Jul 2008 18:41
Tables (Design View) Row Source Type - Value List Row Source - data1;data2;data3 is not updated to the Form view HI, Thanks for assisting me with my previous query. I have almost completed my access database. And now in the process of optimising it. When I first developped the database I had implemented the "List Box" option for some of the data input (by the user) and specified a range of inputs for some of the form... 3 Jul 2008 10:26 |