Search results

funny that's what I did but not all the objects imported - I need to have another go at that next week

it seems to be on certain forms but not on every one within the SAME database but when it works on the first one then it locks up the toolbar - I cant even go back to the form design from design mode really strange

tried a full laptop close down and restart and even that didn't work :banghead::banghead:

I am trying to modify VBA code on a form and for some reason the property sheet is coming up blank - in design mode I get literally nothing, just a big grey box I have exited access and repaired database Anyone seen this and ideas ??

How bizzare - now it seems to be working . . not quite sure what I changed

Hmmm looked at various posts in here but can't get me code to work I an trying to filter records based on entered text in a box on the header so if the Doc No or Doc title contain the entered text it filters by it . . where am I going wrong??:banghead: Me.Filter = "[DocNo] like " &...

Hi Guys, I have the code below to open Word and Excel documents - does anyone know how to open Visio and PDF formats? Set oApp = CreateObject(Class:="Excel.Application") 'Create an instance of MS Excel oApp.Visible = True oApp.WorkBooks.Open FileName:=DocName 'Open...

That was so obvious when you posted it - thanks #BrainFade :D

I have a combo box on a form header to select a persons name to filter the data below but cant get the syntax correct - the combo box name is OwnerFilter Me.Filter = "Owner = OwnerFilter" Me.FilterOn = True this doesn't work - any help please

I've done a search but cant find an answer I'm trying to send data to a spread sheet to create a graph etc im using :- ' DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryCrosstab", "S:\Database\myspreadsheet.xlsx", True however when I re-run it creates a new tab - how...

Hi plog - I sort of reached the same conclusion and have worked on this and it produced the result - horrendous functionality isn't it

I am trying to produces a monthly graph - however in the raw data there is not data for Feb how to I get it to show JAN FEB MAR APR with 0 for Feb rather than just JAN MAR APR ????

main problem is I have different lists that call up the same detail form :-( so requerying in the child would depend upon which parent opened it !!

Maybe my terminology is confusing The main form is in the form of a list of records the other form is a totally separate form and contain the detail for just one record - is it connected using a linked field So not and parent /subform in the context of a single form design

Thanks guessed it probably wasn't open or load but activate / focus etc are a bit more confusing its just a summary table where the data has been changed in the detail

I am opening a subform to change detail and then closing the subform to go back to the summary form. what is the best place to put the Me.Requery code is it on load / activate /open / ongotfocus ........:banghead:

yes it worked ReportName = "rptReport" DoCmd.OpenReport ReportName, acViewPreview, "", "[ID]=" & [ID], acNormal DoCmd.SendObject acReport, ReportName, acFormatPDF, MailTo, MailCC, MailBcc, Subject, MailGreeting & MailMessage & MailSignature, True however it has the...

Ah ok I understand let me try it . . .

works perfectly thank you

am I right in thinking that:- the query selection has to be in the reports underlying query and cannot be in the VBA code ...