Dount VBA code producing Run-time error '3075'

**jeskit** · 07-16-2012, 05:25 AM

Hi,

I am trying to build a bit of code which will search and go to a record in the form Boxes. It shoudl first check to see if the number is valid in the table and then go to that record in the form. The code below keeps producing an error on the line highlighted, it displays the error "Run-time error '3075': Syntax error (missing operator) in expression 'count(Box Number)'."

Please Login or Register  to view this content.

Does anyone know why I keep getting this message? Have I missed out a bit of code? or is the dcount function wrong?

Thank you in advance

Jeskit

**jeskit** · 07-16-2012, 05:43 AM

Hi,

I seemed to have fixed the problem. I added [] around Box Number in the Dcount function line.

However when I fixed that line it produced a different problem. with the line

Please Login or Register  to view this content.

. it produces the error "Run-time error '2498': An expression you entered is the wrong data type for one of the arguments"

Does anyone know what this error means?

**romperstomper** · 07-16-2012, 05:55 AM

What is the value of Ref?

**jeskit** · 07-16-2012, 06:00 AM

Thanks for replying

ref is a integer value which is the Me.Text4.Value

**romperstomper** · 07-16-2012, 06:03 AM

Um, yeah - I can read.

I mean what is the actual value when you run the code and is that a valid record number?

**jeskit** · 07-16-2012, 06:04 AM

sorry I misunderstood what you meant. The value is valid number in the table.

**romperstomper** · 07-16-2012, 06:16 AM

Originally Posted by jeskit

The value is valid number in the table.

Meaning what exactly?

**jeskit** · 07-16-2012, 06:20 AM

Ok the table has box number as its primary key column. However the number 2 into text4 then it wont be record 2 it would be box number 2 which could be for example record number 7 in the table. Does this make sense? So I need code which will first find out the record number which has a box number of whatever is in ref and then open the record in the Boxes form.

**romperstomper** · 07-16-2012, 06:25 AM

Originally Posted by jeskit

Does this make sense?

Not to me in the context of what you have posted. Why don't you just open the form using a filter for the box number you want?

**jeskit** · 07-16-2012, 06:30 AM

Ok, I tried doing it so it would open the form using a filter however it still didn't go to the correct record it just went to the first record.

Please Login or Register  to view this content.

**romperstomper** · 07-16-2012, 06:39 AM

Please Login or Register  to view this content.

rather than

Please Login or Register  to view this content.

**jeskit** · 07-16-2012, 06:42 AM

Thats great it works, however when its filtered you can not then browse through the other records

**romperstomper** · 07-16-2012, 07:01 AM

Well, you can just clear the filter. Alternatively, you could revise your original code to something like

Please Login or Register  to view this content.

**jeskit** · 07-16-2012, 07:25 AM

thank you sooooooo much for all your help works perfectly!!! Thank you!!!!

Dount VBA code producing Run-time error '3075'

LinkBack

Thread Tools

Rate This Thread

Display

Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Re: Dount VBA code producing Run-time error '3075'

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions