Search results

hi the recordset type is dynaset the recordsource is directly to the customer table ??

ok i had data entry set to yes which was why the records weren't showing (doh!!) but i still can't add/edit the records even though the form is bound directly to he table. allow edit/add's/filter/delete are all set to yes?? Thanks.

hi all, i have a form which i've been working with which is/was bound to my customer table. for some reason when i now open the form there are no records and i can't add any new ones. if i create a new form a bind the cust table then it works fine. has anyone got any ideas why it's suddenly...

wow, took me a while to get my head around it but after looking at the link posted by vbaInet it works a treat. It's basically the Form_Current() event you have to use. brilliant, thanks. :)

hi, yes i have the lk_id in my fa_id table. it's set up as fa_id, fa_desc, lk_id 1, desc1, 1 2, desc2, 1 3, desc3, 1 4, descA, 2 5, descB, 2 6, descC, 2

Hi I am trying to set the values of a combo box based on one of the values in my form data source. my form has lk_id (10,11,12,13) lk_description fa_id i have made the fa_id a combo box to show it's description (from another table). i want to filter the combo box based on the lk_id...

thanks GalaxiomAtHome, i'm now creating a temp table and using this as read only for my subform(s) source object. it works perfectly, thanks.

Hi all, pulling my hair out with this one. I want to set a subform recordsource to be a xtab, which you can only do if the xtab has fixed column property set. because i want to refresh the subform every time a new entry is made (therefore a new column) i'm trying to set a sql string to be the...

Hi All, Apologies if the title is unclear. Here's what need to achieve.... Someone will create a new document (in a form) which will go off and query a database to get some header details. Once the form is created i need to create 2 timers. Timer 1 : will be a 45min timer and a pop up needs...

thanks both, just got back round to this. ok so..... I now have a field that comes back with #error as a value and guess what, excel doesn't like this either. Can i replace this with a 0 somehow?? Thanks, Spin.

Hi, I have a query that uses the nz function to 0 some error values. I want to use the query as a source of data in an excel file but excel doesn't recognize the nz function and has decided to throw it's toys out of the pram until I change it. Does anyone know an alternative, excel friendly...

Thanks My date table looks like Year......Month......Week......NewDate(your suggestion) 2010......1............1............2010011 2010......1............2............2010012 2010......1............3............2010013 2010......1............4............2010014...

Hi All, I'm having a problem while i'm trying to create a data set to generate a report. So, the challenge.... - I am tracking the job related skills score of a person by Year, Month, Week - The report is a line chart showing the improvement over last 52 weeks What i have so far... - A query...

Hi, I have a subform which is an audit of an order. is there some conditional formatting which i can do to highlight the most recent event?? Thanks.

hey, i'm building a simple skills database which records the skills of individuals in my company based on the departments required tasks. I'm trying to encorparate a way of recording historic data so i can report on individual improvements over time when it comes to reporting later on. Whats...

it's a newbie. I have 3 areas which i'm reporting on which are 3 dept KPI's. the data comes frmo various sources: tables linked to SQL server tables within access quite a few queries and crosstabs The db is split and sits on a network drive.

well, i'm using the db to run a report and save to disk but the report takes about 2/3mins to run which locks the database so it cant be used. i was hoping to have a smaller db to perform the task of running the report which will hopefully release the main front end db to be used??

Hi All, I'm trying to open a db using the shell command. I keep getting an invalid procedure call though?? here's what i have... Dim rpt_db As String rpt_db = GetDBPath & "WarePro_RPT_prod.mdb" Shell rpt_db, vbHide ...but it's not working. i've had a look about and tried a couple of other...

thanks for the reply. I have checked the db's and both fe/be were set as below?

Hi All, I have created an app which has fe/be mdbs. When i open the fe on a users pc they get an error message saying.... The microsoft jet database engine cannot open the file 'O:\blah...blah\MyDB_be.mdb'. It is already opened exclusively by another user, or you need permission to view its...