Search results for query: *

Thanks for your help Duane - I feel like an idiot now - yes I had an old module called replace from some legacy code.

Duane, here you go : UPDATE STONE SET STONE.STONE_CODE = Replace([STONE]![STONE_CODE],[Forms]![frmSTONE REPLACE]![STONE],[Forms]![frmSTONE REPLACE]![NEWSTONE]); or UPDATE STONE SET STONE.STONE_CODE = Replace([STONE]![STONE_CODE],"be","bb"); both give exactly the same...

Duane, I have tried it in 2003 and 2002 latest SP's. I have substituted the links to the forms with hard code e.g I have a field be-001 and I want to replace the be with bb so I have used replace("stone_code","be","bb") This gives the same error message. Also...

I am trying to use an update query with a field stone_code. In the update to area I have replace([stone]![stone_code],[forms]![frmStone Replace]![stone],[forms]![frmStone Replace]![newstone]) so in theory it should be looking at the field stone for whatever is entered in the form frmStone...

Hello, I have run the upsizing wizard but am not sure on what to now do. I know I have to link the front end to the backend but how do I do that. What files do I link them to/where are they etc. Is it the .mdf and .ldf files? If anyone knows of a document etc which has all the steps it...

I have just split my database which was working fine. I am now getting an invalid call error. Does anyone know of what may cause an invalid call. Is i possibly because when I reference my current db it needs to look at the split tables instead now or something like that. Any assistance...

I was wonderin if it is possible to sync multiple replicas at once or do you have to go through each one.

I have written some code to create a table of contents for a report I have created. I have code in the Detail_Print event so that as you move from the first record to the last record in the report it writes the page number and description to a table. Then I can use this table to show a report...

Tim, I know this is an old question but I was wondering if you ever came across a fix for this as I have exactly the same issue. Thanks VB4ME

Thanks to all of you who have responded - I have not had time to make changes but it definitely explains things to me and should fix my problem

Hello, I have a query that selects data between 2 dates. Say the 1st of May and the 30th of May. The query works fine except that it does not select records for the 30th. If I want to select dates for the 30th I need to push it 1 day ahead. Is there a way of making the criteria inclusive?

I was wondering if it is possible to change the look of a form that is generated using the pivot table wizard. I can get the data etc that I want but I want to change the look of it. E.g the fields are all yes/no fields. I would prefer say to have them look like an option box where if it is...

BingeThinker, you could use the seek command and then reference the field you want and then use the me command to populate the form control. I use something like this - could be an old way but it works for me : dim data as database dim table as recordset set data = currentdb() set table as...

Heather, with the subform option what syntax do I use if the subform is a subform of a subform. I have it working with the subform but not the one embedded in it. I get a 94 invalid use of null error.

The form frmCalendar is a pop up form that allows me to enter a date easily in the field. All I am after is the correct syntax for referring to subforms on forms

I need some help with referencing a subform. I have my main form frmProductLine, in this I have a subform called frmProduct subform. I have entered the following in a field in the frmProduct subform : if (button = acleftbutton) then docmd.openform "frmcalander",,,,,,"frmProduct...

Hello, I have a make table query that gathers info from a table and makes a temp table that I alter and then append back to the original table. The problem is that once I have appended data back into the original table it duplicates the value - EmpID that I am querying on to create the temp...

Your a legend - thanks very much - it is really annoying when it is so simple

Hello, I have access XP and I need to use the .edit option in a module. It does not exist though. I have editmode? and update but no edit. If I use tblName.edit anyway and compile it I get the error saying it is not valid and generally in the past I would just make sure the reference was...

the forms already have the same source. The query I have runs when I click a button and references a field on the form - each form is different so I need it to recognise what form it is on and use that form name.